How to calculate % change between these two years in a beast mode on several columns of data?

Options
pauljames
pauljames Contributor
edited July 7 in Calculations & Variables (Beast Mode)
image.png

IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Tagged:

Best Answer

  • JasonAltenburg
    JasonAltenburg Coach
    Answer ✓

    I know you are asking for a Beast Mode solution but I hope this is helpful to consider.

    One way to do this is to Unpivot your data, then use a beast mode for each year as a column in a pivot table.

    Your columns would end up being along the lines of: Metric Label, 2022, 2023

    2022 defined as:

    CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

    2023 defined as:

    CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

    You'd end up with a table very similar to what you show in your example, and with some tweaking on the coloring and heading rows would likely satisfy the requirement.

Answers

  • Jones01
    Jones01 Contributor

    Hi, what does the underlying data look like?

  • pauljames
    pauljames Contributor

    @Jones01

    image.png

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • JasonAltenburg
    JasonAltenburg Coach
    Answer ✓

    I know you are asking for a Beast Mode solution but I hope this is helpful to consider.

    One way to do this is to Unpivot your data, then use a beast mode for each year as a column in a pivot table.

    Your columns would end up being along the lines of: Metric Label, 2022, 2023

    2022 defined as:

    CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

    2023 defined as:

    CASE WHEN YEAR(`Date`) = '2022' then `Value` else 0 end

    You'd end up with a table very similar to what you show in your example, and with some tweaking on the coloring and heading rows would likely satisfy the requirement.

Categories