Time Interval Question

[evanc]

Hi all,

This may be a basic question, but I am trying to make a time interval for a visualization project I am doing. The specific interval I am using for this example is an every thirty minute interval. I want to plot the number of actions vs. the time intervals, and then look back at the data for previous days at the same time interval.

However, if a certain day (in this example 8/31/15) did not have any actions during a 30 minute interval, my variable will not create/display that time interval.

In this figure, the times for 6 - 6:30 PM and 6:31 - 6:59 PM are a good example of what is missing. How can I create a variable that will allow me to plot a figure like this where the value is 0 for the times where there was no action?

[q30m] =If [Minutes] Between (0;30) Then ([Hours]+" - "+[Hours]+":30 "+[AM-PM]) Else If [Minutes] Between (31;59) Then ([Hours]+":31 - "+[Hours]+":59 "+[AM-PM])

The [Minutes], [Hours], and [AM-PM] variable I created from a date/time stamp of actions. I understand why it is not creating an interval currently, but I can't come up with a workaround.

Please let me know if this doesn't make sense!

Best,

Evan

[Former Member]

Evan,

Can you help in understanding on how you are comparing the data of current day and previous day?

Your formula contains objects as [Hours] and [Minutes]; however, there is no comparison of time intervals.

Is same query fetching intervals for both current and previous day or are there two different data providers?

Could you please elaborate a bit?

Regards,

Yuvraj

[evanc]

Sorry for the delay!

I'm using one query, and the same dimension from the query has all of the date/time values of the actions. I'm trying to roll that up into the thirty minute intervals.

I'm using RelativeValue() to get the previous day's time interval, which works well, except when the current day is missing a time interval (because it won't show me the previous day if the current day doesn't exist)

[amitrathi239]

HI

have you tried with Timedim() function to get the continous dates.

Amit

[evanc]

I have not tried the TimeDim() function, but there's always an action on each day, it's just when the action(s) are during the day.