Waterfall Chart with negative values

[adhudson]

Is there any way to develop a chart like shown below?

• Dimension           – Year Month
• Measure              – No of alerts generated by iComfort Devices.
• Coloring               – Alerts generated by Current Month > Previous Month -> Green                                                                                    – Alerts generated by Current Month < Previous Month -> Red

[Ivan_Bozov]

Hi! As the waterfall chart supports only measures, I guess you will have to create a measure for each month and assign custom colors, e.g. something like

January:

Measure: SUM({<Month={'January'}>}Alerts)

Custom color: GREEN()

February:

Measure: SUM({<Month={'February'}>}Alerts) - SUM({<Month={'January'}>}Alerts) to see if there is an increase or decrease

Custom color: IF(SUM({<Month={'February'}>}Alerts) - SUM({<Month={'January'}>}Alerts) > 0, GREEN(), RED())

March:

You got the drill.

[Ivan_Bozov]

So does this work for you?