Forum Discussion
RZ
3 years agoFrequent Visitor
Dynamic Real-Time Simulation X-Axis
Hello,
I have second resolution calculated/simulated data. The data is forecast data covering the the next year. I am trying to build a demo dashboard that would display a current window of 20 + 1 seconds worth of data. I tried calculated columns or measures or calculated tables by filtering according to current time ... i.e.
LiveViewValue = IF(AND(secondresolution[timestamp]>(NOW()-20/(24*60)),secondresolution[timestamp]<NOW()+1/(60*24)),secondresolution[measurement],BLANK())
But I can't make the calculations, measures that refer to NOW() refresh themselves...
I wonder if it is doable.. Any suggestions?
No RepliesBe the first to reply