LinkedIn
Twitter
In Looker Studio, we can view percentage or absolute changes year-over-year, but I’m wondering if there is way to see the resulting value after the change while working dynamically with a date control filter.
For example, in row 1, sessions show an 80.6% increase from last year. Is there a way to display the original value as well?
Hi Garman, you can do it.
Try the steps below:
Steps:
Create a Calculated Field for the Original Value: Assuming you already have the current value (Sessions) and the percentage change (YOY % Change), you can calculate the original value as:
\text{Original Value} = \frac{\text{Sessions}}{1 + (\text{YOY % Change}/100)}- Navigate to the Data Source connected to your Looker Studio report.
- Add a new calculated field with the formula:Sessions / (1 + (YOY_Percentage_Change / 100))
- Name the field something like Original Sessions.
Add the Original Value to the Report:
- Drag the new calculated field (Original Sessions) into your chart or table.
- Format it to match the desired number style (e.g., whole numbers, decimals).
Ensure Dynamic Compatibility with Date Controls:
- The calculation will dynamically adjust based on the date filter you apply, provided your YOY % Change is calculated on a similar time basis (e.g., weekly, monthly, yearly).
Verify Data Aggregation:
- If your Sessions and YOY % Change fields are aggregated differently (e.g., summed versus averaged), ensure the calculated field respects the same level of granularity.
Example:
- Current Value (Sessions): 1,805
- YOY % Change: 80.6%
- Calculated Original Value: Attached the screengrab for formula,as it was unclear typing here.
This approach ensures the calculated "Original Sessions" field dynamically reflects changes based on the applied date filter or control.
