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
BedrockMission!

Learn More

View all

Sign in to view all badges

Adding Number of Days Variable to Custom Calculated Metrics

Avatar

Avatar
Boost 3
Level 1
dbernsteinaol
Level 1

Likes

3 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile

Avatar
Boost 3
Level 1
dbernsteinaol
Level 1

Likes

3 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 3
Boost 1
View profile
dbernsteinaol
Level 1

11-08-2010

Perhaps I am missing something, but currently when I attempt to define a new calculated metric in Site Catalyst the standard options presented to me are:

average page depth

average time spent on page

entries

exits

page views

reloads

single access

visits

It would be very helpful in my opinion to add  "number of days" to that preset list.  In particular I am looking to create some very simple month projections. 

Ex: (Page Views / Number of Days) * Number of Days in Entire Month.

Thanks

3 Comments

Avatar

Avatar
Level 1
czernay
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
czernay
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
czernay
Level 1

14-11-2010

I'd like to add actual report time scale to the calculated metrics. Like being able to calculate with the number of days I've selected for the report displayed or number of weeks if I selected that for granularity.

 

We really need much more flexibility here. I don't want to have to export every single date into Excel for calculations. I just want to be able to do it all inside Site Catalyst.

Avatar

Avatar
Give Back 10
Employee
justin_grover
Employee

Likes

15 likes

Total Posts

148 posts

Correct Reply

5 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Give Back 10
Employee
justin_grover
Employee

Likes

15 likes

Total Posts

148 posts

Correct Reply

5 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 1
View profile
justin_grover
Employee

22-06-2015

How would you expect this to work if you have had a granularity longer than the selected time frame.

 

e.g. For a 30 day report I want to know how many years.

 

Would the answer be 1 or 30/365 (0.08).

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

114 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

15-02-2018

With the new Approx Count Distinct function, you can now count days within a month and use this metric within another calculated metric.