
1. Re: Count based on calculations?
Walt Reed Dec 13, 2016 7:24 AM (in response to sam.hong.0)Hey Sam,
For the calculation you described, what number does it return?

2. Re: Count based on calculations?
sam.hong.0 Dec 13, 2016 7:28 AM (in response to Walt Reed)Hi Walt,
So there are a total of 100 Product Categories Total. Of these, based on the "Category Calc" feature, there are a total of 16 categories that are "True" as in the number of occurrences has exceeded the thresholds. However, the number I get back is 48.
The screen shot I provided was just 4 out of the 16, but follows the same principle.
Sam


4. Re: Count based on calculations?
Tanner Weil Dec 13, 2016 7:44 AM (in response to sam.hong.0)Try the calc below then sum those values?
IF [Category Calc] = "True"
THEN 1
ELSE 0
END

5. Re: Count based on calculations?
sam.hong.0 Dec 13, 2016 8:03 AM (in response to Walt Reed)Hi Walt,
Yes, please see attached.
Sam

Count Platforms.twbx 27.9 KB


6. Re: Count based on calculations?
Walt Reed Dec 13, 2016 8:27 AM (in response to sam.hong.0)Hey Sam,
Thanks for attaching the workbook. I had some success with: WINDOW_COUNT(COUNT([Product Family])), then compute using: Table (down).
Walt

7. Re: Count based on calculations?
sam.hong.0 Dec 13, 2016 8:37 AM (in response to Walt Reed)Hi Walt!
Thanks for taking a crack at it, but where exactly would I fit this formula?
I was trying to create a text based scoreboard where it would be the below image except to be able to count as "3" actionable events since only 3/8 of the Product Families reached it. Could you walk me through how you would incorporate your formula into this concept? Thanks!!


9. Re: Count based on calculations?
sam.hong.0 Dec 13, 2016 9:10 AM (in response to Walt Reed)Hi Walt,
Very close...I would ideally like just one single box that says "3" Platforms rather than have it split up by the categories and just repeating.
Sam

10. Re: Count based on calculations?
Walt Reed Dec 13, 2016 9:16 AM (in response to Walt Reed)Okay, I see what you're saying. For this part, I had to recreate the Global Calc formula using LOD calculations (it's a long formula):
Then I create a logical field to filter only when the Global Calc = True:
Add this field to the filter, then add the new Global Calc to Text, change to COUNT([Global Calc (copy)]), modify the Text, and you've got the desired result:
Walt


12. Re: Count based on calculations?
Walt Reed Dec 13, 2016 9:34 AM (in response to sam.hong.0)I'm not at my computer at the moment but I believe I had to convert either
Incidents or Global Threshold from dimension to measure, and that should
fix it.
Walt