Issue with grouping


#1

Would like to know if 2 grouping is possible in Redash. I am selecting count as Yaxis , Status as Group by and Month in X axis. I need one more groupingn which is a sub groupin for Month

So basically

  1. For Jan ,Category 1,Category2,Category 3 ,for Feb same.
    For each of these scetions count for each status (serieS).

Please let me know if this is possible


#2

No, Redash supports only grouping by a single column. A workaround is to merge both columns into one.

So instead of:

Month   | Category | Value
------- | -------- | -----
05-2017 | Food     | 1

Your query will return:

Group        | Value
------------ | -----
05-2017 Food | 1