Line Graph – UX Page

Categories: Hints & tips

Show current and last year data above/under each other

Why?

With such a graph, spotting YoY growth/decline is easier.

How to get there?

In the model:

Start with a module that shows the data by time (e.g., headcount by month from January 2021 till December 2022). This module will be referenced to as the source module in this documentation.
Create a new (target) module and create two new line items called ‘Current Year’ and ‘Last Year’:

The line item ‘Current Year’ refers to the data in the source module
The line item ‘Last Year’ refers to the line item ‘Current Year’ with an OFFSET formula: OFFSET(Current Year, -12, 0). In this example, the data is offset by -12 months to get the data for the previous 12 months (vs current 12 months)

On the UX page:

Add a chart card to the UX page and choose the target module as your source
Apply a filter to this grid card that filters for current year months only

This way the graph will show two lines, with the data of current and last year above/below each other, with the x-axis showing the months of the current year.