1 of 1 people found this helpful
You are on the right track with your notion about using parameters, calculated fields and filters.
First create a filter, it sounds like you want to display in months but calculate in days. If so, this should work for you:
Next create a calculated field:
DATEDIFF('day',[Made On Date],today()) <= [Months]
Add this calculated field to the filters shelf and set to "TRUE". You will see your data change as you change the values of the parameter.
Please see attached workbook.
I am assuming, it will be easy to understand. so I am not giving any explanation here.
Let me know if any question OR I have missed something.
Pass Rate Sample.twbx 31.7 KB
I think this will do what you want
First create the parameter as shown
Then the formula becomes - I included a start date parameter that could be changed to using a filter if that is really needed and a formula based on window max of the date filter
and it should return this -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Pass Rate Sample_v10.2.twbx 14.2 KB