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!
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.
This issue is still happening. Any idea of where it resides in list of priority now a days?
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.
try leaving the sort_by option blank and it should work
Thanks for the answer! At least I know I'm not using this incorrectly. Cheers
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.
can you send the link whre we can promote this request?
Why don't you just report on Unique Visitors, in a table having 'Year' as dimension... That should give you yearly unique 🙂