Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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.