Using "desaturate Alerts"/Treemaps with alerts and negative Numbers

Document created by breuber

on Feb 1, 2018•Last modified by breuber

on Feb 2, 2018

Version 3Show Document

Like • Show 17 Likes17
Comment • 6
View in full screen mode

About the solution

If you are using "Desaturate Alerts" in a DV or a Treemap in Combination with an Alert function you can easily see, that the the color is more desaturated, when the Value is getting smaller.
In some cases you might want to invert this for negative numbers (so the most desaturated negative values are those near by zero).

Solution/Project info

Info:

You can easily do this using a simple NEXEL Formular:
if([@a;*;*]<0;MIN( [@a;*;*;Range.Vertical] )-[@a;*;*];[@a;*;*])

As you can see for negative Values the figures are inverted (so that the smallest negative figues are the biggest negative value and vice versa)

Attachments/Print Screens/Videos

16 people found this helpful

Attachments

Using Desaturate Alerts and negative Figures.zip12.8 KB

Outcomes

dzillmann Feb 7, 2018 11:12 PM

Amazing Björn,

I was looking for a solution for this problem before, thanks for sharing! Nigel have a look at Björn's solution, this should fix the treemap problem we have discussed.

Cheers,
Daniel

1 person found this helpful

Actions

ecausse @ dzillmann on Jun 26, 2018 9:49 AM

Hi guys,

Did anyone develop a similar solution without using Nexel ?

Actions

tg_jbaetens Apr 1, 2018 10:56 AM

Hi Björn Reuber,

Maybe also important to mention is that the treemap does not allow to open NEXEL formulas.
In those situations, you will have to open a dataview, create the NEXEL formulas in your dataview and then copy the layout and paste the layout in the treemap.

Thanks for sharing!

All the best,
Jonathan

Actions

rubicon @ tg_jbaetens on Jun 26, 2018 9:56 AM

the treemap does not allow to open NEXEL formulas.

Yes, that is the same with all other charts objects . It is a bit more unhandy to be forced to create a temp dataview if you want to check or change a nexel formula, instead of being able to look directly in the object itself.

Actions

breuber

Jun 27, 2018 10:47 AM

There is another option, instead of using nexel in DV and copying the layout.

Just create a text cube containing the NEXEL Formula (remember that it has to start with =) and than add this cube to your layout and use an algortihm Block with the Option "Formulas In:" and choose your cube containing the nexel formula: Nexel

1 person found this helpful

Actions

dma @ breuber on Aug 12, 2019 4:04 PM

Hello Björn Reuber,

after I implemented your great tip for the use of the color alarm in BOARD 10.3 (in the WIN-Client AND in the WEB-Client), I have massive problems in BOARD 10.5 with the representation of the alarm colors in the WEB-Client (WIN-Client works as usual).
The effects can be seen, I think, quite well in the screenshots.
Somehow the colors in Dataview got a bit confused.

The color display in TREEview doesn't work at all anymore in the negative area.

Do you have any idea why that might be? I couldn't get any help in the support!

Thanks in advance!

Dirk

Actions

6 Comments

dzillmann Feb 7, 2018 11:12 PM
Amazing Björn,

I was looking for a solution for this problem before, thanks for sharing! Nigel have a look at Björn's solution, this should fix the treemap problem we have discussed.

Cheers,
Daniel
1 person found this helpful
Like • Show 2 Likes2
Actions
- ecausse @ dzillmann on Jun 26, 2018 9:49 AM
  Hi guys,
  Did anyone develop a similar solution without using Nexel ?
  Like • Show 0 Likes0
  Actions
tg_jbaetens Apr 1, 2018 10:56 AM
Hi Björn Reuber,

Maybe also important to mention is that the treemap does not allow to open NEXEL formulas.
In those situations, you will have to open a dataview, create the NEXEL formulas in your dataview and then copy the layout and paste the layout in the treemap.

Thanks for sharing!

All the best,
Jonathan
Like • Show 2 Likes2
Actions
- rubicon @ tg_jbaetens on Jun 26, 2018 9:56 AM
  the treemap does not allow to open NEXEL formulas.
  Yes, that is the same with all other charts objects . It is a bit more unhandy to be forced to create a temp dataview if you want to check or change a nexel formula, instead of being able to look directly in the object itself.
  Like • Show 0 Likes0
  Actions
breuber Jun 27, 2018 10:47 AM
There is another option, instead of using nexel in DV and copying the layout.
Just create a text cube containing the NEXEL Formula (remember that it has to start with =) and than add this cube to your layout and use an algortihm Block with the Option "Formulas In:" and choose your cube containing the nexel formula: Nexel
1 person found this helpful
Like • Show 1 Like1
Actions
- dma @ breuber on Aug 12, 2019 4:04 PM
  Hello Björn Reuber,
  
  after I implemented your great tip for the use of the color alarm in BOARD 10.3 (in the WIN-Client AND in the WEB-Client), I have massive problems in BOARD 10.5 with the representation of the alarm colors in the WEB-Client (WIN-Client works as usual).
  The effects can be seen, I think, quite well in the screenshots.
  Somehow the colors in Dataview got a bit confused.
  
  The color display in TREEview doesn't work at all anymore in the negative area.
  Do you have any idea why that might be? I couldn't get any help in the support!
  
  Thanks in advance!
  
  Dirk
  Like • Show 0 Likes0
  Actions

Using "desaturate Alerts"/Treemaps with alerts and negative Numbers

Attachments

Outcomes

Related Content

Incoming Links

Contact BOARD

Discover BOARDVille

Follow us