2 of 2 people found this helpful
Without having an idea about how the natural day counts are used in your production reports, I'm not sure if this sample works for your report or makes it easier for you.
However I created another calculated field to obtain the natural day counts, and a calculated field to filter the last month.
Please check out the attached workbook for details.
It will automatically select the latest month by default
From your description it sounds like you want to filter on the last day of the last month. I used an LOD to figure it out, which might be a little overkill, but it does work.
The updated Tableau file is attached.
Hey Lei Chen thanks for answering!
You have made my day! Your calculated field made me realise I made some mistakes with previous calculations! Thanks a lot!
Happy to hear that!