Cannot find Solution to Availability Reporting in the Modern Dashboard

JCALD6

Hello,

I am trying to create a table widget that reports availability metrics for some custom properties. I have tried 3 different solutions and none of them have worked out. If anyone has a solution to any of the following attempts, please let me know! 

1. We have an existing table in the old dashboard that is reporting percentage availability and site name that we cannot figure out how to translate/copy to the modern dashboard.

2. I am not an expert with SQL or SWQL so I cannot figure out how to write my own query to pull availability information.

3. Using the graphical query builder returns errors when I try to pull from the entity "ContainerStatus" which shows "PercentAvailability" and "PercentMembersAvailability". I cannot find any other properties or entities that mention availability so I cannot figure out another way to report those metrics. 

Appreciate any insight or help, thanks!

christopher.t.jones123

@JCALD6, when you click edit in the top right corner of the widget it should display its data source, from there you should be able to tell what is being used to populate the data. If its not a custom query the graphical builder has a function that tells you what query is being run as part of your data source. To the right of the object you are reporting on is a drop-down menu with an option to "Show SWQL" you should be able to take that and use it as a starting point for building it in the modern dashboard.