Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to dynamically set the range of a Chart.
Suppose I have a chart for sales of products (sunblock, Christmas trees, popcorn and gas). For this example, suppose some items are seasonal. Typically, I would suppress zeros which will produce a pretty useful chart. However, when I combine seasonal sales of items like sunblock (summer) with Christmas trees (winter) I don’t see the month(s) with no sales (Sep-18). So what I would like to do is set the charts min value to the first month with sales for the given selection and set the max value to the last month with sales and let the zero values for the months in the middle to appear on the chart. How can this be accomplished? I appreciate the help!
I don't know where the "suppress missing" option is? Under the measure I see a "custom calculation" but I am not sure what formula to use. Additionally, I did try the "suppress nulls" on the dimension which didn't work either.
Use Set Analysis with Min and Max Date criteria.
SUM({<Date = {">=$(=Min(Date))<=$(=Max(Date))"}>}Sales)