Write query to get current month total

[lochanie1987]

Hi expoenergy,

It works perfectly. Thank You so much for your support.

[yosiasz]

probably not a good idea to cross post @galuppodenis

Monthly Cost, Bar Chart- SQL

I am not familiar with AWS Athena syntax but you want a list of numbers table you can use to left join into your real table. The following is in SQL Server. So your question is really more AWS athena than it is grafana unless there is a way of filling gaps in grafana. ;WITH cteN AS ( select 1 as Number UNION select 2 UNION select 3 UNION select 4 UNION select 5 UNION select 6 UNION select 7 UNION select 8 UNION select 9 UNION select 10 UNION select 11 UNION select 12 ), ctesum as (…

[galuppodenis]

Sorry, it was my first post. I didn’t know how to proceed. My Apologies.
Thank you once again!