Combo chart with accumulated value line

Hi all,

I have a combo chart of daily profit in bars and accumulated profit in line. X-axis is date naturally.

However, when I play with the granularity of the date, the accumulated profit becomes crazy. I guess it's because it sums up all the daily profits of the month instead of taking the last one.

How do I solve this issue for all time periods (e.g. week,month,quarter...).

Thx.