Line chart based on interval

if i choos date interval from 2018-11-01 to 2019-04-30 in chart i need to group by month and year
but in chart i can group by only one value
how can i do this ?

You can modify your query to GROUP BY the elements you need to chart. Redash can do a rudimentary group operation (by a single factor). But your database is the best place to handle anything more complicated than that.

1 Like

in my query i group by year,month,day
i thought if there an ability to do it in chart also