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)))
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.