AnsweredAssumed Answered

Error when trying to create Chart

Question asked by Abrom Douglas III on Sep 23, 2016
Latest reply on Sep 28, 2016 by Frank Schubert

Following the guidance of the 000033281 - Chart Query SQL Guidelines in RSA Via Lifecycle and Governance 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.

Outcomes