Calculated dimension with added metric - set analysis?
I need some help as I have been stuck on this.
I have a table that tells me the customer name, first date of purchase (calculated dimension) and first order value of that purchase. I just cannot get the first order value to match up can anyone help?
first date of purchase is correct: =date(aggr(Min([Reporting Month.autoCalendar.YearMonth]),Name_business))
I've tried several variations of the above for 'first order value' metric and I just can't get it to work including put it into a set analysis. I am going wrong somewhere but I don't know where, any help would be great.