Forum Discussion
How to show device status in a visual
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 AM | Online | Device1 |
| 9/4/2024 8:22:31 AM | Offline | Device2 |
| 9/4/2024 8:22:31 AM | Online | Device3 |
Table 2 shows history as script runs and updates both every hour:
CheckDateTime Status Name
| 9/4/2024 4:21:31 AM | Online | Device1 |
| 9/4/2024 4:21:31 AM | Offline | Device2 |
| 9/4/2024 4:21:31 AM | Online | Device3 |
| 9/4/2024 5:25:31 AM | Online | Device1 |
| 9/4/2024 5:25:31 AM | Offline | Device2 |
| 9/4/2024 5:25:31 AM | Offline | Device3 |
| 9/4/2024 6:30:31 AM | Online | Device1 |
| 9/4/2024 6:30:31 AM | Online | Device2 |
| 9/4/2024 6:30:31 AM | Online | Device3 |
| 9/4/2024 7:20:31 AM | Online | Device1 |
| 9/4/2024 7:20:31 AM | Offline | Device2 |
| 9/4/2024 7:20:31 AM | LostConnection | Device3 |
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
- Ritaf1983
Super User
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
- RRanksFrequent 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!!