unable to sync time with graph

Hi,

I created a graph with Time on the x-axis ( please see attached screenshot ), and created a page selector in my dashboard. I am now trying to sync the Time so that when I select the Time using the page selector, the graph will be updated as well. I already displayed all the Time in the graph, but still I am unable to sync it.

I noticed that in the graph, the quarters are not displayed even though in my source module these are displayed. Is this the reason why I cannot sync it? If yes, then how I can I sync it?

Thanks,

Ana

graph_49229.PNG

Accepted answers

All comments

ArunManickam

Hello Ana,

There is only a workaround to this problem.

1. Create a 'Selection' boolean in your module with value as TRUE

2. Create a 'time period' line element formatted as period (Apply this with User dimension if you wish)

3. Create a view which will act as a source for your graph, this view will have a filter Selection = TRUE

4. Create the graph and publish the graph to a dashboard

5. Now change the formula for the 'Selection' as item(time) = time period

(change the logic if you want a range of dates)

The graph will sync according to the selection in 'Time period' line item.

Thanks

Arun

Ana22

Hi @ArunManickam ,

Thanks for your reply. I actually have a time filter which I used in my source module before publishing in the dashboard. It works for 2019 but if I select 2020, I get the attached error. Please see screenshots for 2019 and 2020 selection. ( I get same error if I select 2018). It only works for 2019.

Thanks,

Ana

ArunManickam

Hello Ana,

The trick is you have to publish the whole time scale with filter, but value as TRUE.

Then you change the formula on the time filter.

Thanks

Arun

Ana22

Hi @ArunManickam ,

It worked!! Thanks for your help 🙂

Regards,
Ana

nathan_rudman

A graph can only display time if the time period existed when you created and published it.

Another "tip" is to use an over extended time range of like 20 years, use it temporarily to create the graph and then change your module back to the normal time range.

jcheng

Hi Arun,

I was applying your solution to a model that I have built and had a follow-up question:

In the "time period" line item, do you input a formula in here, or do you publish this line item to your dashboard and use it instead of a page selector?

Thanks!

Joe

nathan_rudman

it should be published as a selector, although nothing stops you from putting a formula if you have one that makes sense (or you could link it with currentperiod() which is the current period set in the Time tab of the model)

jcheng

That makes sense. Thanks!

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…