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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

2 Questions: Cumulative function seems not to work, and Yearly Unique Visitors not available in Workspace

Lee_Clemmer
Level 2
Level 2

Hi there, two interrelated questions. Background: we have yearly KPIs (e.g. 10,000,000 Visits) and would like to create a dashboard to track progress against year goal.

Question 1: Cumulative function doesn't seem to work, either in Workspace or regular reports.

Calculated Metric definition:

Question 2: Yearly Unique Visitors doesn't appear in the list of metrics in Workspace... why? Can that be activated?

Thanks for any help!

1 Accepted Solution
hyderziaee
Correct answer by
Employee
Employee

Hi Lee,

I checked and this is a known issue with the Cumulative function. The engineering has this on low priority currently.

The workaround would be to use Report Builder and then use Excel functions to achieve this for now. Not sure if you would like to take this route though.

-Hyder

View solution in original post

0 Replies
Løjmann
Level 5
Level 5

Why don't you just report on Unique Visitors, in a table having 'Year' as dimension... That should give you yearly unique 🙂

/Løjmann

hyderziaee
Correct answer by
Employee
Employee

Hi Lee,

I checked and this is a known issue with the Cumulative function. The engineering has this on low priority currently.

The workaround would be to use Report Builder and then use Excel functions to achieve this for now. Not sure if you would like to take this route though.

-Hyder

fdesouza
Level 1
Level 1

can you send the link whre we can promote this request?

hyderziaee
Employee
Employee

Hi Flavio, 

You will need to open a ticket with ClientCare and ask them to attach your reference to the Engineering ticket - AN-132415

Do provide the business impact as well.

-Hyder

Lee_Clemmer
Level 2
Level 2

Thanks for the answer! At least I know I'm not using this incorrectly. Cheers

jpbehrens
Level 2
Level 2

Hello,

This issue is still happening. Any idea of where it resides in list of priority now a days?

hyderziaee
Employee
Employee

try leaving the sort_by option blank and it should work

thomasw79329949
Level 1
Level 1

Is this going to be fixed properly anytime soon? Right now it just sorts at random when I don't select something to sort by and it must be sorted ascending whereas i need to sort descending.

Damu80
Level 1
Level 1

Any progress on this issue? Still cant make cumulative unique visitors matching with uunique visitors total.
If I have a business target to drive 50.000 unique visitors on my site on current year, how to follow that?
Calculated metric "Cumulative unique visitor 2" is inflating numbers. If the correct valueis 4297, the cumulative value is 4748.

Damu80_1-1642506909470.png