Date aggregation not working after upgrade to 2.6.0

by noni » Mon May 09, 2016 12:05 am

Hi,

I have upgraded to Dashboard Designer 2.6.0 and the Date aggregation option is not working properly. E.g. my simple pre-upgrade graph worked with the following setup:
Category = Date;
Sum = Quantity;
Date Agg Unit = Month; and
Step = 1

This showed a sum quantity for each individual month. After upgrade the graph only renders a result for the first month (no other months). Same issue if I select:
Unit = years and Step = 1; or
Unit = months and Step = 2

The only time aggregation works is when Step = auto.

Can you please investigate why only Step = auto is working.

Examples of differing results below.

Thanks,
Noni
Attachments
Chart Date Agg by Month - Auto working.png
Graph renders results if Step = Auto
Chart Date Agg by Month - Auto working.png (31.28 KiB) Viewed 491 times
Chart Data Agg by Month - Step 1 not working.jpg
Graph does not render results if Step = 1
Chart Data Agg by Month - Step 1 not working.jpg (62.86 KiB) Viewed 491 times
noni
 
Posts: 6
Joined: Tue May 03, 2016 12:25 am

by Dmitry Kozlov » Mon May 09, 2016 2:32 pm

Hi,
Make sure that you are requesting all the rows from the list (Data Source -> SharePoint List -> Rows).
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm

by noni » Mon May 09, 2016 9:48 pm

Hi,

Nothing has changed in the chart settings since upgrade. It was working before upgrade now it is not. I have checked the rows and they are all being requested.

Looking at the screen shots I sent you will see that just changing the Step from Auto to 1 eliminates results from all future months, this is not a row issue.

Please assist.

Thank you,
Noni
noni
 
Posts: 6
Joined: Tue May 03, 2016 12:25 am

by Dmitry Kozlov » Tue May 10, 2016 3:41 pm

That was an issue in the app. Please, try to open the chart in the designer and re-save it. Let us know whether the problem has gone.
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm

by noni » Wed May 11, 2016 1:38 am

Fixed now, thank you.
noni
 
Posts: 6
Joined: Tue May 03, 2016 12:25 am


Return to Dashboard Designer for SharePoint 2013