All,
Not sure if this is even possible, but I am trying to create a report so show the current status of certain systems. My users want to be able to see the time a certain system has been in a state, and they want the data to be live. This is what my data looks like:
System Status Last Modified
Telephone Red 12/16/2022 13:30:00
Computer Green 12/15/2022 08:30:00
So, if it's 15:30 now and "telephone" went red at 13:30, then my duration needs to be 2 hours. However, I can't figure out of this is even possible - everything I find in searching the internet requires a start/end column to calculate duration, but I don't have an end column. I do have a query which is visualizing the last refresh time.
Is this even possible? If not, I will tell my users they simply need to make to with the last update time, and figure out the duration from there. But I'm wondering if I could accomplish a duration calculation based on variables? If it would be helpful, I could split my data into different tables for each system type, but I'd rather not if it could be avoided.
I am using a Sharepoint list as a datasource, but eventually we are moving to Dataverse for a direct query.
