Displaying data between two time ranges

[Anonymous]

Dear All,

I have data available in a similar timestamp format : 11/2/2016  11:28:00 AM.

I have a requirement wherein I need to display records/data between a particular time range ie. 9:00 AM to 5:00 PM using the above timestamp.

Could you please with this query.

[Tanya_Sharma9]

Below is the format of my TimeStamp column:

[mdmukramali]

Hi @Tanya_Sharma9 ,

You can't use the same condition in Expression.

you need to use the Condition in Set Analysis .

Upload the sample file i will help you in writing the Set analysis syntax.

Thanks,

Mukram

[Tanya_Sharma9]

Hi @mdmukramali ,

Please find attached the data.  I want to display a value where value for 'TAG A' is divided by sum of values for 'TAG B' and 'TAG C' for the maximum minute(5/4/2021 2:00 AM).

For E.g:

=(4/(2+1))  for '5/4/2021 2:00 AM'

Also, I want to display this above calculated data for the last one hour(1:01 AM to 2 AM).