· Bar 1 - Number of cases for that particular week where the sub status changed to ‘ABIA’.
This is the formula I have: COUNTD(if [Sub_Status__c] = 'ABIA' THEN [Id] END)
· Bar 2 - Number of cases for that particular week where the sub status changed to ‘BIA’
This is the formula I have: COUNTD(if [Sub_Status__c] = 'BIA' THEN [Id] END))
· Bar 3 - Total number of cases overall for that particular week with the sub status = ‘ABIA’
(What I am trying to show is, in week 13 there were 231 cases, in week 12 there were 456 cases, week 11 there were 111 cases)
This is the formula I have: COUNTD([Id])
· Bar 4 – Total number of cases throughout time with the sub status = ‘ABIA’
This is the formula I have: {FIXED : COUNTD(if [Sub_Status__c] = 'ABA' THEN [Id] END)}
Ideally, it would look something like this.
So you have a filter to only show last 13 weeks? and how is that implemented ?
What happens if you do this:
1) REMOVE the filter on your time dimension
2) order the values so you have 'other' as the first column and the other columns should be in the right order as well
3) create a calculated field that is this:
LAST() < 12
4) Drag this new calculated field to Filters, hopefully it shows true and false and choose True. If it doesn't work properly, right click on the field in Filters, choose Compute Using > Table across and then choose True
5) Then your running total will work properly.
I know you can't post confidential data, but a workbook with some dummy data and a graph mockup that is close to what you're really trying to do would help a lot more :)
-----------------------------------------------------------
2022 Tableau Forums Ambassador
Based in Sydney, Australia (GMT+10)
Please upvote my helpful replies and choose Select as Best Answer if it really is the best :)
