Set a time range for graph?

Question & Answer
, , ,
1

Hello,

If i have a graph, with x axis being a datetimestamp, how can I set it to only show data that falls between the range of 0800hrs to 1800hrs?

Thanks.

2

Hello @dixerio,

If you have a separate column that just contains Hours, then you could try to apply that column as a filter on your graph. If you do not have a separate column with hours then you could potentially create a calculated field to extract the hour from the datetimestamp and apply that new column as a filter to the graph.

For example:

  1. Create calculated field:

    image
    image341×268 5.3 KB

  2. Apply Filter:

    image
    image406×800 19.3 KB

  • You can hard code the hours in the filter, or use parameters and controls to set the upper and lower bounds, but you will need to match the format you define in the calculated field
3

Hi @dixerio

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @dixerio

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!