In Workspace, I am using the percent change column to track YoY changes. I right click on a column and choose the date range I want to compare to, and the percent change column is generated.
The percent change column seems to be generated in a way that is hard coded to the two input columns. Is there a way to set up a percent change column that is just attached to the two columns, and is NOT hard coded? It would be much easier to change date ranges and segments if I could do this. Currently if I change date ranges or segments on my columns, the percent change column does not always accurately reflect the change in date range or segment.
I know the summary change visualization does this, attaches to 2 cells instead of being hard coded. Can the percent change column do that as well?