Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Update totals update for filtered results

Avatar

Avatar
Boost 50
Level 4
scotta1101892
Level 4

Likes

60 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
scotta1101892
Level 4

Likes

60 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
scotta1101892
Level 4

17-10-2017

Couldn't find the older thread on this so recreating it. When a table in Workspace has its results filtered, the metric totals at the top do not update to reflect the totals of only the filtered results. This causes a ton of confusion among report recipients. Please fix!

14 Comments

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

17-10-2017

agree on this idea, would be very helpful!

there are two options for a work-around:

a) use filter, select desired row items and right click „display only selected rows“. this will change the col sums. but be careful: if you move the dimension, the filter on the rows keeps applied, might cause some trouble later in (if you don‘t remember that you made this manual filtering)

b) use segments and drop segments on items (dimension items) to break down

Avatar

Avatar
Applaud 5
Level 1
kelseyjoy
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
kelseyjoy
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
kelseyjoy
Level 1

08-12-2017

Yes! This causes a lot of confusion is our organization! It would be ideal if both total options could be available, both the filtered results & the absolute total.

Avatar

Avatar
Level 1
MeggieC
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
MeggieC
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
MeggieC
Level 1

11-12-2017

Yes please! Would be really helpful to see the filtered metric totals.

Thanks for the workaround view to @urs.boller.

Avatar

Avatar
Ignite 5
Level 3
florianag
Level 3

Likes

18 likes

Total Posts

39 posts

Correct reply

0 solutions
Top badges earned
Ignite 5
Give Back 5
Give Back 3
Ignite 3
Give Back
View profile

Avatar
Ignite 5
Level 3
florianag
Level 3

Likes

18 likes

Total Posts

39 posts

Correct reply

0 solutions
Top badges earned
Ignite 5
Give Back 5
Give Back 3
Ignite 3
Give Back
View profile
florianag
Level 3

11-01-2018

I'd recommend the option with segment only.

The main issue with using "display only selected rows" (which is why for me it is always the last option), is that the total will reflect the sum of the rows, not the actual total after deduplication. This can cause issues when the metrics included are particularly sensible to deduplication, for example unique visitors.

Avatar

Avatar
Give Back 10
Level 3
pradeep_jaiswal
Level 3

Likes

12 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 10
Ignite 5
Ignite 3
Give Back 5
View profile

Avatar
Give Back 10
Level 3
pradeep_jaiswal
Level 3

Likes

12 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 10
Ignite 5
Ignite 3
Give Back 5
View profile
pradeep_jaiswal
Level 3

20-05-2018

plz provide this feature as to business folks its confusing

Avatar

Avatar
Level 1
russmartin16
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
russmartin16
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
russmartin16
Level 1

15-06-2018

Agreed. Not the default/intuitive result I would expect.

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

29-07-2019

Avatar

Avatar
Ignite 1
Level 2
melissaa3700183
Level 2

Likes

3 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Shape 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Ignite 1
Level 2
melissaa3700183
Level 2

Likes

3 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Shape 1
Boost 3
Boost 1
Applaud 5
View profile
melissaa3700183
Level 2

29-07-2019

The problem I find with option a) on top of what has been said is that the table doesn't update as new items appear. this means that analysts need to go back to the workspace and manually update the tables; in a large organization this is not a sustainable workflow.

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

29-07-2019

We are currently working on making totals update when filters are applied (so users don't need to apply segments to get the desired total).

Avatar

Avatar
Boost 5
Level 2
b_e_l
Level 2

Likes

13 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
b_e_l
Level 2

Likes

13 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
b_e_l
Level 2

29-07-2019

Yay!! Do you have an estimated ETA?