Forum Discussion

RRanks's avatar
RRanks
Frequent Visitor
2 years ago
Solved

How to show device status in a visual

Hi,

I need help with a Device status chart.. I am exporting the status of some devices every hour to a table. I want to track them via some sort of graph.. doesn't have to be the same as the example below but anything that will show the same thing in some way would be great.

 


I have tried playing around with the data by adding to a visual, but I just keep getting counts and not the name values.

I have 2 tables btw.. 1 with Current(Newest Status) and then one that maintains the history.

 

I have a test .pbix file if someone can tell me how to share it?

 

Table 1 shows current / most recent collected data:

CheckDateTime              Status    Name

9/4/2024 8:22:31 AMOnlineDevice1
9/4/2024 8:22:31 AMOfflineDevice2
9/4/2024 8:22:31 AMOnlineDevice3

 

Table 2 shows history as script runs and updates both every hour:

CheckDateTime              Status                   Name

9/4/2024 4:21:31 AMOnlineDevice1
9/4/2024 4:21:31 AMOfflineDevice2
9/4/2024 4:21:31 AMOnlineDevice3
9/4/2024 5:25:31 AMOnlineDevice1
9/4/2024 5:25:31 AMOfflineDevice2
9/4/2024 5:25:31 AMOfflineDevice3
9/4/2024 6:30:31 AMOnlineDevice1
9/4/2024 6:30:31 AMOnlineDevice2
9/4/2024 6:30:31 AMOnlineDevice3
9/4/2024 7:20:31 AMOnlineDevice1
9/4/2024 7:20:31 AMOfflineDevice2
9/4/2024 7:20:31 AMLostConnectionDevice3
  • Hi RRanks 
    Graphs are meant for displaying data relationships, not for presenting the data itself, which is why the output on the Y-axis will always be some form of numerical aggregation. If the goal is simply to view statuses by devices, you can create a table or matrix with indicators. For example :

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

2 Replies

  • Hi RRanks 
    Graphs are meant for displaying data relationships, not for presenting the data itself, which is why the output on the Y-axis will always be some form of numerical aggregation. If the goal is simply to view statuses by devices, you can create a table or matrix with indicators. For example :

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

    • RRanks's avatar
      RRanks
      Frequent Visitor

      Hey Thanks. This seems to have gotten me off to a start to on how to show this data. While I used some traffic light symbols and added Building for device I am quite happy with the solution thanks!!