For problems like this, I find it helpful to break up the calculation steps a bit.
First, we have to change your date filtering to something that is parameter driven. Because putting a month filter on "June 2018" will always limit your records to the calendar month. Since you want different behavior, we need a different approach.
I built 2 parameters, one for the anchor month (June, 2018) and another for the date handling (mid-month or month-end). Using those selections, we can build out the start and end dates we want to use for filtering the data. Here is my Start Date calc.
I tried to add comments to explain what is going on here. Short version, if you want month-end handling, it just uses the parameter value, which is the first of the month. If you choose mid-month, it uses the parameter value to go back to the 16th of the previous month.
I built a similar calc for End Date, and then built a filter that pulls only dates in between the start and end date.
I'm attaching my workbook so you can see all of the steps. You can test the results on Sheet77.
Hope this helps!
Dashboard 11.twbx 638.2 KB
What version of Tableau are you using I only have 10.4
Thats Great Thanks
Is there a way I can put ALL in the 'Month' Parameter
What should the date range be when All is selected? And the two parameters Month and Review Parameter which will go first, e.g. if month is 'All', does Review parameter still work?
Basically if the 'All' is selected then we would all the months displayed with the correct figure (The same as if we were to select this individually), With this I hope to display the data in a more graphical sense like a line graph. But I am not sure if this is possible.?