-
1. Re: LOD Metrics that only include prior dates
Vladimir Khvan Dec 5, 2018 8:00 AM (in response to Kevin Hansen)Have you tried to add Order date to your LOD as a 2nd level?
Like {FIXED [Customer_name], [Order_date] : SUM(Order_amount)}
-
2. Re: LOD Metrics that only include prior dates
Kevin Hansen Dec 5, 2018 8:07 AM (in response to Vladimir Khvan)Wouldn't that only give me the average in that period? What I need is the average in all period up to the date in view; i.e. excluding "future" dates in the FIXED formula
-
3. Re: LOD Metrics that only include prior dates
Vladimir Khvan Dec 5, 2018 8:16 AM (in response to Kevin Hansen)Do you want to get scores monthly? Or just 1 aggregated figure?
Perhaps you can share your workbook
-
4. Re: LOD Metrics that only include prior dates
Kevin Hansen Dec 5, 2018 8:24 AM (in response to Vladimir Khvan)currently I am returning one aggregated figure per customer, but I would like to bring a date into view and return a figure for every month that would be like a point-in-time (like if I looked at last month it would be as if I had the 1 aggregated figure for all the data up to that point in time)
unfortunately cannot share this book, but I could try to replicate with SuperStore data
-
5. Re: LOD Metrics that only include prior dates
Kevin Hansen Dec 5, 2018 10:31 AM (in response to Kevin Hansen)attached an example of my issue and wrote some more specifics in the caption
-
6. Re: LOD Metrics that only include prior dates
Vladimir Khvan Dec 5, 2018 10:46 AM (in response to Kevin Hansen)Thanks, Kevin.
Unfortunately, I'm not able to open it because it was created in a newer version of Tableau (I'm using 10.3). Will try it from my personal machine with the latest Tableau ver installed later today
-
7. Re: LOD Metrics that only include prior dates
Kevin Hansen Dec 5, 2018 11:17 AM (in response to Vladimir Khvan)I appreciate it!
-
8. Re: LOD Metrics that only include prior dates
Mahadevan Krishnan Dec 6, 2018 11:19 PM (in response to Kevin Hansen)