Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Time units in Calculated Metrics

Avatar

Level 2

3/18/11

I would like to have time units in the calcuated metric editor to calculate average metrics: for example I would like to calculate average daily unique visitors as Total DUV / Number of days considered in time frame because the sum of all DUV doesn't mean anything significant, but the daily average is more useful!

2 Comments

Avatar

Level 6

6/7/11

I agree. A calculated metric for [selected number of days] dynamically populated with the number of days in the date range of a report or dashboard reportlet. I would like to have two dashboard reportlets containing calcuated metrics for "Average Daily Revenue", "Average Daily Orders", "Average Daily Visits", etc. One for the current timeframe (e.g. this week, this month), and one with my reference timeframe (e.g. last week, last month, this year)

 

This was also requested in these posts:

 

https://forums.adobe.com/ideas/8119

 

http://ideas.omniture.com/t5/Adobe-Idea-Exchange-for-Omniture/Adding-Number-of-Days-Variab le-to-Custom-Calculated-Metrics/idi-p/1828

 

http://ideas.omniture.com/t5/Adobe-Idea-Exchange-for-Omniture/Aggregator-functions-for-Dat e-Range-s/idi-p/456

Avatar

Level 1

9/6/11

In addition, if we could use a calculated metric based on date ranges to achieve a % change metric, then we could determine the fastest rising and fastest declining products (ie Number of orders yesterday compared to last month), which would be very helpful.