
Contributor III
2021-06-07
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated dimension with added metric - set analysis?
Hi All,
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.
681 Views
1 Reply

Contributor III
2021-06-07
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WOuld be good if you attach your qvf file.
648 Views
