Solved
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 optio...
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.
