topic Re: Aggr Line Chart help in App Development

Aggr Line Chart help

Mon, 01 Aug 2016 03:37:27 GMT

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!

Re: Aggr Line Chart help

kaushiknsolanki — Mon, 01 Aug 2016 07:36:46 GMT

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

Re: Aggr Line Chart help

sunny_talwar — Mon, 01 Aug 2016 11:22:44 GMT

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)))

Re: Aggr Line Chart help

Mon, 01 Aug 2016 14:30:21 GMT

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

Re: Aggr Line Chart help

Mon, 01 Aug 2016 14:31:15 GMT

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

I am attaching a file to this.

THANKS!

Re: Aggr Line Chart help

Mon, 01 Aug 2016 14:35:40 GMT

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

Re: Aggr Line Chart help

sunny_talwar — Mon, 01 Aug 2016 15:14:34 GMT

Does this look right?

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

Re: Aggr Line Chart help

Mon, 01 Aug 2016 15:25:38 GMT

YES!

Thank you so much! This really helps!