Aggr Line Chart help

[#1]

Please help!
I am creating a cumulative line chart and I am having some issues,

The data is retrived from a QVD,  and the date in the QVD starts from 9,15,2015

The line chart is for current month, that's why there is only one line. I dont know why the line moves down on the 15th for current month.

Here is the chart:

Dimensions: Day - Year

Expression - aggr(Rangesum(above(TOTAL(SUM ({<Month = {$(=Month(Today()))} , MonthYear=, WeekDay=>} [TIPS Amount])), 0,rowno(TOTAL))), Year, Month, Day)

Please explain why the chart dips on the 15th.

Thanks!

[kaushiknsolanki]

Hi,

Its not possible to understand this issue, unless you share the sample data with us.

If possible share the sample .qvf file which will show your problem.

Regards,

Kaushik Solanki

[sunny_talwar]

How about trying this:

Aggr(RangeSum(Above(TOTAL(SUM ({<Month = {$(=Month(Today()))} , MonthYear=, WeekDay=>} [TIPS Amount])), 0, RowNo(TOTAL))), (Year, (NUMERIC)), (Month, (NUMERIC)), (Day, (NUMERIC)))

[#4]

Hi Kaushik, Here is the file. please let me know if can provide any clarity to it. THANKS!

[#5]

Hi Sunil, could you else what the numeric value will be?

I am attaching a file to this.

THANKS!

[#6]

Attaching the QVF and the QVD generator code to the original post.

[sunny_talwar · Accepted solution]

Does this look right?

Read about sortable Aggr function: The sortable Aggr function is finally here!

[#8]

YES!

Thank you so much! This really helps!