Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a straight table with a field named 'exp_id'. In my data model, I also have two other fields, StatusStartDate, StatusEndDate, and CalDate. In the straight table, I have this
But when I go to my straight table, I am greeted with this "Invalid Dimension" error.
What concept am I missing here? What I am trying to say is
"Only show the exp_id property if the StatusStartDate comes before the smallest selected CalDate"
Any help is greatly appreciated.
For a calculated dimension, you need an Aggr() function or use TOTAL within Min(CalDate)
1) Aggr(If(StatusStartDate < Min(CalDate), exp_id), exp_id)
2) If(StatusStartDate < Min(TOTAL CalDate), exp_id)
For a calculated dimension, you need an Aggr() function or use TOTAL within Min(CalDate)
1) Aggr(If(StatusStartDate < Min(CalDate), exp_id), exp_id)
2) If(StatusStartDate < Min(TOTAL CalDate), exp_id)
Thanks a bunch for your help Sunny. Do you mind explaining the science behind why I have to use such functions?
When using Aggregation in calculated dimension, you need to specify a dimension, or tell your expression that you are looking for overall Min by using TOTAL. Unless you do that, calculated dimension don't really work. I might not have done a great job explaining it, but may be check this link out on Calculated Dimensions