How to calculate % change between these two years in a beast mode on several columns of data?
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU! 😎😎😎
Best 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.
0
Answers

Hi, what does the underlying data look like?
0 
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.
0
Categories
 All Categories
 1.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 83 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.2K Visualize
 2.3K Charting
 518 Beast Mode
 26 Variables
 555 Automate
 129 Apps
 408 APIs & Domo Developer
 18 Workflows
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 343 Distribute
 85 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 81 Manage
 80 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 78 Community Announcements
 4.8K Archive