Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys ,
I am trying to turn an expression into a dimension .
Details : i am calculating the last purchase date of a product by using the MaxString function , every product has multiple purchase dates and this shows its last .
what im trying to do is to filter and select the last purchase date in order to check which product dates to which year . but i cannot introduce the maxstring function as a calculated dimension .
any ideas about how to make this possible?
Thanks in advance.
try aggr(maxstring(purchasedate),product)
Note, I think you should make sure your dates are real dates and not strings so you can calculate with them. For example max(purchasedate) instead of maxstring(purchasedate). And calculations on numbers perform better than calculations on strings.