Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Create line chart with 2 dims (Quarter and area) and 1 measure .
I had a filter in the measure that will display the last 3 quarter:
count({$<Quarter={'$(=$(V_Max_1_Q))','$(=$(V_Max_2_Q))','$(=$(V_Max_3_Q))'}>}Tests)
I want that the chart will display always 3 quarters even there is no data in one of the quarter (display with value 0 ). Currently, it shows only the quarters with data (attach example).
Any Idea?
Thank you!
Hi Ruti,
Please do as follows:
In properties -> Dimension-> Check Display all Data checkbox and uncheck suppress value is null.
Thanks,
Arvind Patil
Thank you for your response..
The Dims marked with option of Show null value and no limitation but the quarter still does not appear ..
I think it related to the filter in the Measure:
count({$<Quarter={'$(=$(V_Max_1_Q))','$(=$(V_Max_2_Q))','$(=$(V_Max_3_Q))'}>}Tests)
How you have defined variables V_Max_1_Q,V_Max_2_Q,V_Max_3_Q?
Try,
count({$<Quarter={'$(=V_Max_1_Q)','$(=V_Max_2_Q)','$(=V_Max_3_Q)'}>}Tests)
Hi,
It's define :
SET V_Max_1_Q="maxstring(Quarter)";
!