2 Questions: Cumulative function seems not to work, and Yearly Unique Visitors not available in Workspace | Community
Skip to main content
Level 2
May 11, 2017 7:18 PM UTC
Solved

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

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Hyder_Ziaee
Hyder_ZiaeeAccepted solution
Employee
May 16, 2017 3:26 AM UTC

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

9 replies

thomasw79329949
New Participant
Nov 12, 2018 10:13 PM UTC

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.

Translate
Level 2
Jan 18, 2022 11:33 AM UTC

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.

 

 

 

 

Translate
Hyder_Ziaee
Employee
Aug 3, 2018 1:01 PM UTC

try leaving the sort_by option blank and it should work

Translate
Level 2
Aug 2, 2018 8:32 PM UTC

Hello,

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

Translate
Level 2
Jun 7, 2017 12:56 PM UTC

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

Translate
Hyder_Ziaee
Employee
May 26, 2017 7:17 AM UTC

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

Translate
New Participant
May 24, 2017 4:06 PM UTC

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

Translate
Hyder_Ziaee
Hyder_ZiaeeAccepted solution
Employee
May 16, 2017 3:26 AM UTC

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

Translate
Løjmann
Level 5
May 13, 2017 11:09 AM UTC

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

/Løjmann

Translate