0 votes
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.
asked by

1 Answer

0 votes

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.

answered by
I see trans > sum > trans back > total.... nice idea

Thank you cperdigou.
888 questions
919 answers
890 comments
1,383 users