Show month where there is no data in a histogram

Get Help
1

this is my postgreSQL query :

SELECT 
    count(*) as number,
    to_char(event.creation_date, 'MM-YYYY') as my_date
 FROM event 
JOIN event_resources ON event.id=event_resources.event_id 
WHERE {{date}}
GROUP BY my_date
ORDER BY min(event.creation_date) asc;

and this is my result :

58%20PM
58%20PM1551×541 15.4 KB

i would like each mm-yyyy to appear event when number=0. i can't change the x-axis scale (it is on ordinal). for instance, 01-2020 doesn't appear on this graph

can someone help ?
have a nice day

2

Hi @armandviolle
You would have to make a query to a table, which has all the dates you're looking for and then join in your other query, which fills it with the data you want.