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

pauljames

JasonAltenburg

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.

Jones01

Hi, what does the underlying data look like?

pauljames

@Jones01

JasonAltenburg

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.