Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,892
Community Members
 
Community Events
165
Community Groups

Problem aggregating data by date with Table Filter and Charts

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!

1 answer

1 accepted

Hi @Laura Campbell _Elements_ ,

Please check the Options tab of the Pivot Table macro:

Wed 1-1.png

Wed 1-2.png

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.

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.

Screen Shot 2021-07-28 at 17.22.10.png

 

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.

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

407 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you