ram
04-24-2025Data Storage
Formula
Hi
I want to show the total task percentage
i have a task count which i achieved by dupcount([Student id ]) = 337
i got the total count which is Grand total which i got by grand total option on a task which is 22,315
now my formula should show 22,315/337 = 66.21%
could you please help me with the formula
Thanks
Hi ram,
Is Task the category/slicer in the widget? If yes, you can calculate each task’s contribution to the grand total using this formula:
DUPCOUNT([Student ID]) / SUM(Task, (DUPCOUNT([Student ID]))
The denominator in this formula uses a feature called multi-pass aggregation. You can find more information and an example here: https://docs.sisense.com/main/SisenseLinux/build-formulas.htm#combine-data-aggregate-functions.
Let me know if you have any follow-up questions.