...
When creating a widget, if you select the 'Advanced' button you will have the ability to upload your own custom SQL.
The SELECT section of your SQL must contain fully qualified columns and specify certain columns.
Pie charts must return name or my_name, description or my_description and count.
Line charts must return date or my_date, description or my_description and count.
The WHERE section of your SQL must contain WHERE @filter so Open-AudIT knows to restrict your query to the appropriate Orgs. SQL not containing this condition will result in the widget failing to be executed.
An example widget SQL showing devices counted per location.
...