Not getting the proper charts on the user defined logical sql
Summary:
I have written a sql statement by performing a left join between two subject areas. Have got the desired output.
However am note getting the expected outcome with the pie/graph chart with that data.
Content (please ensure you mask any confidential information):
Sample Data:
Count_of_Employees Goals_Status
270 GOALSET
7 NOGOALS
Pie Chart is showing only single slice for all 277 count. What could be the issue.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):