Could you please attach the workbook so that I can play around with it?
Unfortunately the workbook has sensitive information held on it so i'm unable too.
Anything you can suggest off the top of your head?
Thank-you for your time and effort into looking into this.
Unfortunately i was unable to download the workbook because it's a later version of Tableau than I have here at my organization.
I was actually hoping for a total'd numerical amount, rather than two viz's showing the difference below and top.
So it would be something like this:
Current Month: 120
Previous Month: 130
As mentioned before ideally i'd like to have the change alter periodically as well.
I'm struggling mainly to get this done because of the 'ExampleCount' already being an aggregated value combined with an integer value (Activity Month) condition.
Any further help you can provider would be appreciated!
Here is the result I got as a text format instead of the viz:
Here are the steps that I did:
Step 1: create an aggregated count based on the month condition, like following:
Step 2: create the window sum for the previous month's count and current month's count
Step 3: calculate previous month's count by subtracting the current month's count from the window sum we got in step 2
Step 4: Calculate the change between current month and previous month
Please let me know if it works for you!
Apologies for the delayed response, i was on leave from work for a while.
I tried your method above, unfortunately i hit an issue straight away.
The 'Count' which you put in the first window is actually an aggregated value within Tableau I.E: COUNTD(IF [Submission Status] = 'Yes' THEN [Org Name] END)
Obviously this raises the error of having trying to create a case with a non-aggregated field with an aggregated field.
I'm guessing trying to aggregated the activity month would defeat the purpose of the later calculations.