Date aggregation not working after upgrade to 2.6.0

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

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

Chart Date Agg by Month - Auto working.png815×943 26.4 KB


Chart Data Agg by Month - Step 1 not working.jpg799×901 51.2 KB

2

Hi,
Make sure that you are requesting all the rows from the list (Data Source -> SharePoint List -> Rows).

3

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

4

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.

5

Fixed now, thank you.