1 of 1 people found this helpful
Not sure if someone will have a better idea, but one solution is to take what you've done and add one more step:
This is under the assumption you will always have TBL in your viz as well. You could do this with a FIXED as well, but I thought exclude might be better in case you need to add other filters. Final result (only done for pending):
Would this work? Similarly you could use a WINDOW function:
([Request Status] = "Started" OR [Request Status] = "Not Started" OR [Request Status] = "Submit")
THEN [Instance Name]
Thanks so much for the reply that solution is really helpful! Unfortunately the bar chart is supposed to include all the business lines except for TBL. The values that you get are correct and the idea is right but I really need to show the chart without the TBL column so I don't think those LOD(?) calculations will work. Is there any other way you think I could try solve this?
Thanks a million,
Thanks so much Bryce, lifesaver
Excellent! Glad you got it sorted.
If you can, please select one of the response as Correct to close the thread so others can find when needed. Best of luck with the rest of your build!