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

jo_maassen_1

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.

Jo 

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 

 

 

 

jo_maassen_1

Hi Rob, 

Thanks anyway for thinking about a solution! 

best regards, 

Jo