This website uses cookies. By clicking OK, you consent to the use of cookies. Read our cookie policy.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Solved!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

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.

1 Solution

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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.

Solutions shown first - Read whole discussion chronologically

3 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Thank you cperdigou.

Thank you cperdigou.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content