You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Auto Increment Date Variable

Received Response
10
Views
4
Comments
edited Dec 18, 2017 10:17PM in Reporting & Analytics for B2C Service 4 comments

Content

Hi all,

Was curious if there was a way we can auto increment a date variable - say hours - to show all increments, regardless of whether there is data for that interval or not?

For example, if we run by hours, goes 1,2,3,4,5 etc. but if there is no data for say hour "3", then the rows would show as 1,2,4,5 (skip the interval).  Would like to add "3" and "no value" in the column next to the date interval.

Thanks!

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!