Colours for Risks & Opportunities chart

Zuzana Reed

Hi,

I would like to use the red and green alert for my risks and opportunities chart. It is a very simple bar chart with one data view. I turned on the data alert on the cube but it doesn't come through in the chart. I looked at every option in the chart but I can't see anything in the settings.

I can't use waterfall for this because it is not a proper variance analysis. This data is just a visual representation of some data which we want to add to the dashboard.

Anybody has any suggestions?



------------------------------
Zuzana Reed
Financial Analyst
ELEXON LIMITED
United Kingdom
------------------------------

Bettina Clausen

Hi Zuzana,

please check out this link. This might help you to implement red and green alerts.
Long story short: with the alerting functionality you won't be able to reach the desired outcome. You'll need to add some algorithms for positive and negative values and color them respectively.

Hope this helps!

Kind regards,
Bettina

------------------------------
Bettina Clausen
Team Leader
Board Community
Germany
------------------------------
-------------------------------------------

Zuzana Reed

Hi Bettina, thanks you for this suggestion!!. Really appreciate it. Yes it will work with the workaround. Hope they can implement this with the easy option soon, it would be very useful for some of our dashboards.

 

Zuzana

 

-------------------------------------------

Zuzana Reed

Thank you Bettina!! Really appreciate it.

------------------------------
Zuzana Reed

------------------------------
-------------------------------------------