I am fairly new to Tableau, so this may be a simple problem, but I and am getting very stuck so hope that someone here may have a good idea for me. I am trying to create a dashboard where I display distinct count of users at the last day of the year, or last day of the month, or last day of the week .
This flexibility is important as some of my users are only interested in monthly data, while others need to get week's worth of data.
I found this tutorial Top 15 Tableau LOD Expressions (Practical Examples) , and number 9 seemed to be exactly what I needed which I implemented.
However, for my dashboard, I also need to provide filtering on other dimensions (4 of them), and this is where I started seeing problems with the above solution. I quickly learned that this is because of the filtering order in Tableau, i.e. dimensions filters are applied before the LOD calculation. Suddenly I was no longer getting last day of the week/month, but just the last day for the data set after the dimension filter is applied.
For example here is what I want to be able to do with my dashboard:
1. total number of distinct users on the last day of the week/month
2. total number of distinct users on the last day of the week/month that are still 'active'. If there are no active users on the last day of the week/month, I want to see 0. What I get is the last date in that week/month when one of the users was active.
Hope this is not too confusing... I attached a small dashboard that demonstrates the problem when filtering is applied.
Is there any way to implement something like number 9 in the Top 15 Tableau LOD Expressions (Practical Examples)
but also allow for filters to be applied to the set after LOD calculation.
Are there any other options? Thanks in advance...
I am using tableau desktop version 10.3.5.
MaxDatePerMark.zip 8.9 KB