Chart not showing all the values of x-axis

[Starfish2201]

Hi Gurus,

I have a chart in my report page,  and I am using SQL (native) to pull the data from data source. In the SQL, I am doing count. I want to show count of projects in each region/area. But when I point the chart to the native SQL and run the report, its picking only value for x-axis( the first value) and only displaying 1 bar.

Can anyone please help me in this?

Thanks
Paddy

[blom0344]

Uh, did you use region/area in the chart for the series?

[Starfish2201]

Hi blom0344,

Yeah I already added that to the series.

However I assigned the query to the report page and that resolved the issue.

Thank you so much for your response !!! :)