Calculate the count of OPEN on the first day of April.
Calculate the count of OPEN on the last day of April.
Perform the same math problem you show in your question above.
You will have use the DATEPART function to get the day, month and year of the Report Date for both the close and the open counts. Wrap these up in a COUNTD function to get the number of Open Reports that have a status of OPEN.
In reality, this is one problem that translate well from Excel to Tableau.
I would just copy and paste all this in for you to see, but network security will no longer allow copy paste in the browser.
Could you please share the calculations if possible. I am actually getting confused while applying calculations.
I will take a look at doing this at home this evening. If I create it here at work, I will not be able to upload due to security.
Did you had the chance to look over it. Thank you.
Sorry, I have been away on a fishing trip. If you still need this, I will take a look.
Just checking if we can close off this thread?
Many thanks, Ciara
[Program Manager - Tableau Community]
This is not mine to close since I did not open it.
Sent from the iPhone of Timothy Dines.
Hi Tim, no problem, I've edited the post. Thanks Ciara