Expand my Community achievements bar.

The Analytics Community Lens news letter for February 2024 is now here! Come see upcoming events and what's been going on in the community!
SOLVED

Participation calc metric slowing down report builder

Avatar

Level 1

Hi,

So I recently added the new participation calculated metric to one of my report builder requests and it seems to have a huge impact on the time it takes to refresh the workbook.  In the past all the queries took about 5 minutes to refresh, but since I added the participation calc'd metric I had the refresh fail three times on me already.  I deleted out 10 less important queries in hopes of trying to ease the total load, and it is still taking well over 30 minutes now.  Anyone else have any issues like this?  I'm only using the metric on two queries, and each are for a one week time frame, for a top ten pages list.  If this continues to be an issue, I may have to just remove that metric from the query.

Thanks in advance for the help

Chris

1 Accepted Solution

Avatar

Correct answer by
Level 10

Since this is an older post, I'm assuming you've solved this issue. Incase others find this post, I'll post the link to the documentation below:

https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetric-workflow/...

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Since this is an older post, I'm assuming you've solved this issue. Incase others find this post, I'll post the link to the documentation below:

https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetric-workflow/...