Following the guidance of the 000033281 - Guidelines for writing Report Chart SQL Queries in RSA Identity Governance & Lifecycle Knowledge base document, I am getting the below error within the 'Display Attributes" tab:
"The data for this chart is invalid. Ensure the query is correct and returns the expected number of columns"
After writing the query and testing it, the data displays perfect in the preview. Here's the query:
(select * from
SELECT bu.NAME as "Business Unit",COUNT(*) as "count"
FROM BUSINESS_UNIT bu
JOIN USERS usr ON usr.BUSINESS_UNIT_ID=bu.ID
WHERE usr.IS_TERMINATED ='False'
GROUP BY bu.NAME
I am ultimately trying to create a Doughnut 2D chart style to simply breakdown the count of users in each business unit. I then would like to place this on a welcome dashboard. Does anyone have any guidance as to why this is failing? Thanks in advance.