...
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.
The SQL cannot contain WHERE @filter OR. That SQL will not be executed, however WHERE @filter AND queries are allowed.
An example widget SQL showing devices counted per location.
...