Problem aggregating data by date with Table Filter and Charts

[Laura Campbell _Elements_]

I'm trying to reproduce the tutorial that is presented https://stiltsoft.com/blog/2017/10/table-filter-and-charts-with-dynamic-spreadsheets-in-confluence/

to aggregate data in an Elements Spreadsheet table in order to display it in a Chart, but I seem to have problems concerning the date format because I can't get the pivot table to aggregate data by month, and that means the last step of creating the chart doesn't work (in any case I keep getting a message from the chart that the date format is not correct).

I have not used the Confluence like dates that are available in Elements Spreadsheet, just regular numbers, like 01/02/2020

In the tutorial video at the bottom of the linked page, at 3:43 there's an example of how the data should be aggregated by month, but despite following the video, my pivot table only displays data for one tab at a time. I have de-activated the option to treat each tab as a separate data set.

Any tips on other things to check, or work arounds?

Thanks!

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Laura Campbell _Elements_ ,

Please check the Options tab of the Pivot Table macro:

The Date format needs to be adjusted to the one that you use for your source table.

And for the Chart from Table macro (if you need to create a time line) the appropriate date format (the one that you get in your Pivot Table if your chart is based on this pivot) should be chosen in the Adjustments tab inside the macro settings.

[Laura Campbell _Elements_]

Hi @Katerina Kovriga _Stiltsoft_ 

I have the Date format updated, and also the correct date period aggregation set, but when the page is displayed, it only aggregates 1 tab of the Elements Spreadsheet. So I do see a table with all the January data aggregated, but the other months that are on different tabs are not aggregated like in the tutorial.

If I click on a different tab in the Elements Spreadsheet, the new tab is displayed aggregated, but I can't get all the tabs to be displayed.

[Katerina Kovriga _Stiltsoft_]

Oh, maybe it could be the compatibility problem then.

Please raise a support request for us and attach the page storage (upper right corner -> menu ... -> View Storage Format). We'll recreate your page and look into the issue - is it something local or a global problem.

And please provide us with the version of the Table Filter and Charts that you use - the current one is 7.7.4 (is it the one or do you use smth older).