Diff_hours filtering to a range >= X

Pcap
New Member

Attempting to make a table calculation to find work being completed X hours from the time the work was assigned  diff_hours(${start_time}, now()).  This code gives me my desired output, but I’m looking to add a >= X hours to only see cases older X.   However, when I change the code to diff_hours(${start_time}, now()) >= X the numerical value changes to a yes/no.   

0 1 88
1 REPLY 1

Hiya!

This makes sense, as evaluation of the expression diff_hours(${start_time}, now()) >= X  will be true or false. So you can add it as an extra column for example and then use “Hide No’s” option to hide for the visualization the rows where this expression is not met. 

Top Labels in this Space