I should think this would be easy but I can't figure it out. If you look at the attached screenshot you'll see that I've got a simple data set of customer sales by month. All I want is to have the chart always show twelve months in the axis, even if the selected customer has no sales in some months.
Brian, It's due to the calculated dimension. It's actually showing "all" values as the values for the dimension are the ones available at the moment in the field Fiscal_Date_Period.
Create this dimension on the script side already and you should be good with Show All Values and unchecking Suppress zero-values like Oleg pointed out.
check that you have the missing Months as field values in a Calendar or somewhere else. Try also checking "Show All Values" , in combination with "Suppress when value is null" for the Dimension.
No, still isn't working. I must be missing something obvious which will, no doubt, make me feel like an idiot when someone figures it out. I'm attaching the app if you don't mind taking a look.
Brian, It's due to the calculated dimension. It's actually showing "all" values as the values for the dimension are the ones available at the moment in the field Fiscal_Date_Period.
Create this dimension on the script side already and you should be good with Show All Values and unchecking Suppress zero-values like Oleg pointed out.
