Dynamic Display of Time Periods on charts

Hello Experts,

I am trying to use dynamic display of time periods in my module it is absolutely working fine with grid in module, I have used the formula to get this dynamic display(see the below screenshot).

Now, I am publishing the module(grid) through column chart, whereas I am getting this below error after the chart is published in dashboard.

I have read the chart article(Data selection & Dynamic chat update), it is saying in example, "For example, say you have a grid containing discrete monthly values with aggregated quarterly totals. If you select a combination of months and quarters, quarters are aggregated values not discrete values, so only the monthly values will be charted. However if you select only quarters, they will be charted because quarters are all aggregated values."

So, please suggest how I can avoid this error with any formula applying for any new line item or if there is another approach kindly let me know.

Thanks

Accepted answers

All comments

usman.zia

Hi SK,

I have created this type of chart before and the best solution I found was to create a new line item which is the lowest time period level and then to add the individual time element line items together as a summary line item and then to remove the time summary or change summary to forumula.

I hope this helps @CommunityMember82499

Thanks,

Usman

CommunityMember82499

Thanks for your reply Usman,

Could you please share the step by step process with screenshots, so that it will give more clarification on what I am looking.

Regards

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…