Dynamic Display of Time Periods on charts
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.