-
1. Re: can you summarize by Running Total?
swaroop.gantela Nov 28, 2018 8:05 PM (in response to Tijan Senghore)Tijan,
For the first part, I'm wondering if it might be useful to make a separate calculated field for each Tier,
for example, for Tier1:
WINDOW_SUM(IF [Running Sum Customer Count]>=21 THEN 1 ELSE 0 END)
These three would be placed on the Measure Shelf with Table Calculation Settings shown below.
This creates many copies of the value, but this can be filtered down to one with INDEX() on the Filter Shelf.
Please see workbook v10.3 attached in the Forum Thread:
https://community.tableau.com/thread/288851
-
288851tier_v10.3.twbx 4.5 MB
-
-
2. Re: can you summarize by Running Total?
Tijan Senghore Nov 29, 2018 9:54 AM (in response to swaroop.gantela)Hi Swaroop, that worked wonders!! Thank you. I now can summarize by Tier. The only thing I had to change on the Summary tab is the Date field. I used the "NewCustDateForTierGroup" field instead and that gave me the desired results. Thanks so much. Now onto the second part:):)
Tijan