I am trying to build a pie chart with the Data Visualizer. This is the query:

select name, count(*) as amount from #___matches
join #___maps on map = map_id
where exists
(select 1 from #___leagues where league = league_id and region = 'XXX')
group by name, map
order by amount desc

one pie chart can be found here:
www.aapg-stats.com/9-info-articles/15-toplist-na
the other one here:
www.aapg-stats.com/9-info-articles/14-toplist-eu

both charts do not include the very first result with the highest count. If i just run the query then i see 13 rows for the first and 12 rows for the second query but the pie charts have one result less each.

Can you tell me how to display all results?

EDIT: In both settings in the backend I have added the appropriate amount of colors for both text and for the piece of pie.

Hello,

Set "Show header" parameter to "Yes" in module settings.

Regards,
ARI Soft

worked. thank you.