I get error when i try to make a graph which is dynamically updating with date selection.

Hi,
I am trying to create a dynamic graph for stock overview (see picture below).

I created a table with dates in the columns and I have 3 line items.
I added a time filter on the module that is triggered by the selection of the graph start and graph end date.
The module is published to a dashboard with the time filter in place
Also the graph is published to the dashboard with the same time filter in place.
If I change the dates, the module is updated in the dashboard, however the graph is not updated and is shown as it was published.

I tried to make the time synchronisation available, but that is not possible because a graph cannot have more then 200 columns. And one year of dates in the module is more than 200 columns 😞

Can anybody help how I can get the below graph setup dynamically?

Already many thanks upfront for your help.

issue 200 items.PNG

Accepted answers

All comments

Misbah

@jo_maassen_1

Chapter 4 Section 2 Rule 9 - Publish Charts with full filters initially

See below

https://community.anaplan.com/t5/Chapter-4/4-02-09-Publish-charts-with-full-filters-initially/ta-p/81270

That should help

Misbah

rob_marshall

@jo_maassen_1

I thought I had a great workaround for you and it works for the data module, but not for graphs. The workaround was to change the time dimensionality to Months so you can publish it, and then change the module back to Days. In theory, this works and it does work for modules, but not for graphs as the graphs keep the months in the axis.

Sadly, I don't think this is going to work for you.

Rob

jo_maassen_1

Hi Misbah,

Thanks for your reply!

Unfortunately this solution does not solve the issue. I tried to do this, but 1 year has 365 days. The graph only excepts 200 days. So i get an error when i try to create a graph without a filter.

I cannot believe that we are the only company with a graph with daily information (values). So, i hope that there will be another solution.

thanks again,

jo_maassen_1

Hi Rob,

Thanks anyway for thinking about a solution!

best regards,

Misbah

@jo_maassen_1

Yes, Classic UX has that limitation but with New UX you can create graphs and charts with umpteen number of days. I am not sure if Anaplan has any roadmap to solve that issue. You can raise this with Anaplan on support@anaplan.com

Misbah

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…