A Traffic Light approach on Pivot sections in Hyperion Interactive Reporting

{Posted from a BI-Training Hyperion instructor}

Looking to crate a traffic light in a pivot?

One approach is to use the spotlighter. But the problem here is that you cannot compare two fields against each other, say an Actual and Goal. The solution is the use of a computed item.

Create a computed item in the pivot using an if condition.

Say if (actual > goal) {'great'} else {'underachiever'}.

This would produce a fact with either word in the colulm.

Now use the spotlighter to focus on the new fact, and if ='great' Green ; = 'underachiever' Red.

From here, if you dont acutally want the words great or 'underachiever', you could play around with the Fonts, perhaps using an up arrow or down arrow, using windings.