LS has a powerful chart. It is Bar-diagram. It can show more than 2 column data.
I have developed SQL-query for AD Users. It have to be used with this type chart.
You should use report's name with prefix "Chart:".
Chart: Status of AD users
Query:
Select Top 1000000 tblADusers.Userdomain,
Sum(Case
When tblADusers.IsEnabled = 'false' Then 1
Else 0
End) Disabled,
Sum(Case
When tblADusers.IsEnabled = 'true' Then 1
Else 0
End) Enabled,
Count(tblADusers.Username) All
From tblADusers
Group By tblADusers.Userdomain
Order By All Desc
At first, you have to enable checker to scan Disabled Users:
After creation of the report you can add Chart Report on Tab via drag&drop it
Choose Bar-type and show label. My result:
