Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Bar chart shows correct data, but when I make a selection in the age dimension, chart show no data.
example:
Chart:
Selection made (number 11):
I think it is something to do with the dimension formula, but cannot figure out.
Formula for age:
=floor(if(GetFieldSelections(Type_Load) = 'Latest Update', (Today() - [EightD.D1_KPIDate]) / 30,
if(GetFieldSelections(Type_Load) = 'Official Extraction Data', ('$(vMaxCutofDate)' - [EightD.D1_KPIDate]) / 30)))
any ideas?
Thanks as always!
Hey Jose
The only thing I can suggest is to check if Type_Load field selection is still the same when you select your age group on a chart. Calculated Dimensions might act weird while making selections.