Forum Discussion

ram's avatar
ram
Data Storage
04-24-2025
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...
dashboards & reporting
  • TriAnthony's avatar
    TriAnthony
    04-28-2025

    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.

TriAnthony's avatar
TriAnthony
Sisense Employee
04-28-2025

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.