Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Workspace - Percent Change

Avatar

Level 1

Hello,

Is there any way to recreate percent change? Meaning I would like to have not the difference between two time periods in % but in absolute value. For example: column 1 = 50€ and column 2 = 100€; the percent change would give me a result equal to 100%; but I would like to have equal to 50€.

I'm not able to edit the Percent Change eventough I saw a video that states I was supposed to. If I could create a metric with 'target date range' and 'compare date range' the problem could be solved but i don't know how to, or if it's even possible. Any suggestions? Thanks a lot!

1 Accepted Solution

Avatar

Correct answer by
Level 1

Hello, the other day the pencil was not available.. I tested again just now and it's there. I was using another computer maybe that was the reason. Thank you anyway :)

View solution in original post

2 Replies

Avatar

Employee Advisor

Hi Ana,

If you would like to have it in difference of numbers. Simply (1) remove the denominator from the calculated metric, (2) change the value from Percent to Decimal

Or is this something you are not able to do? What issue are you facing?

-Hyder

Avatar

Correct answer by
Level 1

Hello, the other day the pencil was not available.. I tested again just now and it's there. I was using another computer maybe that was the reason. Thank you anyway :)