Grafana with dynamodb, create query that groups by month and counts rows

Grafana PostgreSQL
1

**1 - Convert field type
Field
transaction_date
as
Time
Input format
YYYY-MM-DD
2 - Group by
transaction_date
Group by
3 - Add field from calculation
Mode
Reduce row
Operation
transaction_date
Calculation
Count
Alias
Count
Replace all fields

This is not working for me, as the days or months are just counted as 1 row. How to do this type of query?

2

how would you do this query outside of grafana?

3

I ended up figuring it out with trying different transformations over and over again and adding multiple queries to work together. Thanks.

4

Sounds like overkill?

Why not no use it’s own query language