By Bryan Castro, GoodData
The purpose of headline reports is to place metrics front and center on your dashboards. Month-over-month change is a key metric that always stands out. This recipe uses custom formatting to make month-over-month change stand out even more.
The first metric captures the number of tickets created this month. The expression is:
- SELECT # Tickets WHERE Month/Year (Created) = This
- # Tickets is found in the pick-list Metrics folder.
- Month/Year (Created) is found in the pick-list Attributes folder.
- SELECT # Tickets WHERE Month/Year (Created) = Previous
- SELECT This month - Previous month
- This month and Previous month are found in the pick-list Metrics folder.
To make this metric stand out more, you can apply conditional formatting. In order to do this, you'll need to go back to the What panel.
In the What panel, double click Variance metric . In the Metric Format section of the Details column, enter in the following formatting:
This formatting enables you to clearly see if there are increases or decreases in the number of tickets. If there were more tickets in the previous month (the number is below zero), there will be a red arrow pointing down. If there are more tickets this month (the number is above zero), there will be a green arrow pointing up.
Here's a screenshot of the table report once all three metrics have been created.
To change this to a headline report, you'll first need to deselect the This month and the Previous month metrics from the What panel. Click on the Headline icon on the top right.
Here's the final headline report: