Subscribe Bookmark RSS Feed

Why the time as data filter option doesnt work in Graph builder?

sanqub

Community Trekker

Joined:

Jan 11, 2016

Dear community members,

 

I am trying to find a simple correlation of "time of day" and defect percentage. For this, I am using graph builder and time as data filter. Instead of using "ordinal data type" and a checkbox, I would prefer to have "time as continuous" as I can easily select any time range for instance 07.30.00 - 09.30.00

However, I find data filter doesn't work in this case. Do you think binning is only option in this case?   

 

Thanks for your help.

4 REPLIES
David_Burnham

Super User

Joined:

Jul 13, 2011

I'd probaby start off by trying a semi-continuous scale by using the HOUR function to create an 'hour of day' column

-Dave
sanqub

Community Trekker

Joined:

Jan 11, 2016

Thanks, I have just tried that, quiet useful.
txnelson

Super User

Joined:

Jun 22, 2012

I don't know if this comment will be useful, however, I just changed the format for the Time of Day column, from h:m:s to Day:hr:m:s and it allowed the data filter to work without issue.

Jim
sanqub

Community Trekker

Joined:

Jan 11, 2016

Its brilliant trick, it works.
However, it changes the values. For instance Time: 16.39.43 has changed to 00.07.20.17.
Thanks for your help.