How do I create sum or total data in same column on dashboard?

wtuntana
wtuntana Registered Posts: 10 ✭✭✭✭
For example, I have this data set

Name Week1 Week2 Week3 Week4
A 10 20 30 40
B 41 31 21 11
C 3 4 5 6

I want the dashboard shows

Name Week1 Week2 Week3 Week4
​A 10 20 30 40
B 41 31 21 11
C 3 4 5 6
Total 54 55 56 57


or

Name Week1 Week2 Week3 Week4
​A 10 20 30 40
B 41 31 21 11
C 3 4 5 6
Total 54 55 56 57
--------------------------------------------------------
Grand total 222

Or modify the data table to use sum in the same column.



Thank you.

Best Answer

  • cperdigou
    cperdigou Alpha Tester, Dataiker Alumni Posts: 115 ✭✭✭✭✭✭✭
    Answer ✓

    With such a small table the easiest is to use a recipe to get the final table you want, then publish it to the dashboard.

    Here is an example using only a visual prepare recipe, it involves transposing, computing the sum, then transposing back.

    Another solution to only get the sums is to use a prepare recipe to Fold your data (the opposite of a pivot), then use a groupby "Week" to get the sums.

Answers

Setup Info
    Tags
      Help me…