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

[Lee_Clemmer]

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!

[Løjmann]

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

/Løjmann

[Hyder_Ziaee · Accepted solution]

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]

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

[Hyder_Ziaee]

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]

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

[jpbehrens]

Hello,

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

[Hyder_Ziaee]

try leaving the sort_by option blank and it should work

[thomasw79329949]

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]

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.