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

Analysis Workspace: Color Code Drilldowns with Zero Results

Avatar

Avatar
Ignite 1
Level 2
jeremyl57529056
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Shape 1
Boost 1
View profile

Avatar
Ignite 1
Level 2
jeremyl57529056
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Shape 1
Boost 1
View profile
jeremyl57529056
Level 2

15-10-2020

Hello.  I had an idea for a new feature in Analysis Workspace.  

 

Today, when you create a Freeform table, you can set the background color with a variety of options.  And when you use the drilldown feature of the table, the color coding then applies to the sub line items.

 

However, when the drilldown gets "zero" results, there is no way to colorize (in red, for example) the fact that the drilldown was 'unsuccessful'

 

For example - look at this freeform table.

jeremyl57529056_0-1602780094655.png

Since there are no line items under the header of "prop43", there is no colorization. 

In cases like this it would be ideal if Analysis Workspace could add a 'no results' row line item with a value of 0 under the 'header' line so the colorization settings would apply to the 'no results' line item.

 

The value of having something like this is when you have a dashboard with 50+ drilldowns and you want your audience to be able to quickly scan down the dashboard looking for 'red' colors - which would potentially indicate a problem.  With no colorization for 'unsuccessful' results the dashboard doesn't easily call out issues like this.