Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart with year as the dimension, and my calendar table has dates from 2000-2012. I have two expressions, number of calls and change per year, but I only have measurements for calls since 2004, so I would like to only show the years with measurements, i.e. 2004-2012. If I remove the second expressions, only 2004-2012 are shown, but when I have both expressions, 2000-2012 are shown with no values for the first four years. How can I remove years without measurements when I have two expressions?
The values for the second expressions does not have its own bars, but are shown on top of the first expressions bars.
you could try. if('Expression1'>0 and 'Expression2'>0,Date,'-') as a dimension (supress null values) Regards RL
Thanks, but it made no difference.