Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Does this look right?
Read about sortable Aggr function: The sortable Aggr function is finally here!
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
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)))
Hi Kaushik, Here is the file. please let me know if can provide any clarity to it. THANKS!
Hi Sunil, could you else what the numeric value will be?
I am attaching a file to this.
THANKS!
Attaching the QVF and the QVD generator code to the original post.
Does this look right?
Read about sortable Aggr function: The sortable Aggr function is finally here!
YES!
Thank you so much! This really helps!