It's perhaps confusing because you are mixing a time domain and frequency domain analysis. While this is certainly a useful thing to do in some circumstances, it's important to keep the differences between the two in mind. Since this is the beginner's forum, a simple way to distinguish the two is that the time domain is what one normally sees on an oscilloscope, with a voltage that is, in some fashion, a function of time. The frequency domain is what one might see on a spectrum analyzer, a number of discrete spectral lines of certain frequencies with amplitude and phase relations. With full knowledge of the signal described by one domain, it is possible to transform it to the other domain without error.
First, I think you are looking at a filter capacitor following a diode rectifier as might be found in a power supply. In this case, the driving voltage waveform (time domain) is a rectified sine, either full wave or half wave as the particular circuit may be.
If we look at the waveform in the frequency domain, via a Fourier transform, or as you might see it with a suitable spectrum analyzer, you will find a DC component (frequency 0 Hz) plus sine waves of varying phase and amplitude at multiples of the input frequency. The capacitor does not attenuate the DC component, since it has infinite reactance at 0 Hz (1/wC = infinity when w = 0. w is omega, 2*pi*f). However, it will have a finite reactance at the other frequencies in the waveform, thereby attenuating them. Thus the RC filter alters the amplitude and phase of the non-zero frequency spectral components and the result is a different waveform, one with less AC ripple and more dominated by the DC component of the spectrum.
If you prefer to look at the circuit in the time domain, then I would think of the capacitor, as has been suggested, in terms of stored charge. At any particular time, the capacitor will have a certain voltage across it and that voltage corresponds to a particular charge stored in the capacitor. Q=CV, where Q is charge in Coulombs, C is the capacitance in Farads and V is the voltage in volts. More importantly when we are looking at a time changing voltage is the change in voltage versus change in charge and current. I don't want to make this overly complex, but it requires a bit of elementary calculus to understand the relationship. I'll skip the math and concentrate on a simple physical description. As the driving voltage increases, more charge is "pushed" into the capacitor. Pushing charge into the capacitor tends to hold the voltage across the capacitor at a slowly changing value compared to how it would vary with time in the absence of the capacitor. Likewise, if the driving voltage decreases below the capacitor's stored voltage, the capacitor releases some of its stored charge and "pushes" the charge back into the circuit, thereby holding the voltage more constant with time to a greater extent than in the absence of the capacitor. A tiny bit of the calculus involved is i = dq/dt where i is current and dq/dt is the rate of change of charge. In other words, current is the change in charge with time.