Ideas Welcome! Looking for Design Help

Legacy Contributor

Hi,

Ideas Welcome!!!! 

Each week I publish a report from excel to report how we are tracking to the monthly/yearly budgets and goals.

*If today's actuals are greater than where we should be then that cell is shaded green, if we are below where we should be then that cell is shaded red.

*If Current GM Projection is greater than monthly budget then that cell is shaded green, if  we are below budget then that cell is shaded red.

I am open to ideas on how to design this in Birst maintaining the way to easily identify if we are meeting or not meeting our expected budget or goal, please and thank you! 

Thanks,

Kersten

Dan Rosen

If you wanted to display this as KPIs on a dashboard, you could use indicators against a budget measure to display higher or lower symbols color coded appropriately. If you wanted to build this as a table in visualizer, you could apply conditional formatting to change the text color and add an indicator symbol in a similar way. As far as I know, the only way to shade in the background of a cell in a report would be to do the same thing in a designer report which has background formatting available