This calculation below works with COUNTD and a Running Total applied later and returns the desired visual. Picture 1.
IF [Academic Year]="2017-2018" THEN (IF NOT ISNULL([Unique ID])
THEN [Unique ID]
However, I'd like to embed the count and running total into the calculation so the calculation result is a measure.
I tried this, but it's not working. Look at Picture 2.
IF MIN([Academic Year])="2017-2018" THEN RUNNING_SUM(IF NOT ISNULL(COUNTD([Unique ID]))
THEN (COUNTD([Unique ID]))
Did you try this way
running_sum(countD(IF [Academic Year]="2017-2018" THEN (IF NOT ISNULL([Unique ID])
Thank you arvindgarg
If you are still available to help, I have a follow-up question here Stop running total line in the last data point. It continues as a flat line...
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...