Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

"Percent Change" in Workspace with granularity

Avatar

Avatar
Level 1
jennym54703541
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
jennym54703541
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
jennym54703541
Level 1

05-03-2021

Is there an ability to calculate percent change on a line by line basis (such as broken down by all days in a month)? I have built a calculated metric (since we do not have the automatic Percent Change feature when a table is broken down by day/week/month, etc.) that will show the aggregated percent change, but it breaks my Workspace. I am looking at revenue for this month to date, and built a rolling date range to look at this month to date last year. Ideally, the table would be displaying March 1st - 4th. As soon as I apply my calculated metric for percent change, the table becomes 369 rows long and displays March 2nd, 2019 through today and the percent change is not accurately reflected. I've attached screenshots of an example comparing this month to last in our dev report suite. Here is a link about the same issue, posted about in 2018: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/quot-percent-change-quot-in-w...

 

Below is the layout I would want, just with an added column for the percent change on each of the four lines:

ideal layout.PNG

Below is what I get as soon as I add my calculated metric:

broken layout.PNG

Very curious to see if anyone has found a solution for this.

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

180 likes

Total Posts

543 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

180 likes

Total Posts

543 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile
yuhuisg
MVP

06-03-2021

This seems to be an Analysis Workspace bug that has also been reported at Analysis Workspace Create Metric from Selection Bu... - Adobe Experience League Community - 399148.

You should file this with Client Care promptly.