Cannot do a count by rows by source view [SOLVED]

I was trying to follow along

as I’m trying to draw multiple series, but when I pulled down on the count by rows dropdown, I don’t see where I can add source and created_at as per the document. I know that I have multiple groups with counts available on the data

thanks, Joyce

I’m presuming you are referring to the 2nd method (using the question builder, not a dashboard to combine) on the page you link to.

I think it might be the illustration of the user interface on that page that is a little outdated/inaccurate with by no more in the VIEW box, like:

https://www.metabase.com/docs/v0.30.0/users-guide/images/MultiSeriesQueryBuilder.png

It now has the breaking out in a separate GROUP BY section, like:

https://www.metabase.com/docs/v0.30.0/users-guide/images/binning.png

Let me know if I’m talking about the right thing — or not? :smile:

Hello Jornh

Yes, I’m referring to the 2nd method (using the question builder, not a dashboard to combine). I was able to do a multi series by pivoting a column and splitting the aggregations into multiple columns, but it would be super nice, if I can do that easily with the GUI.

The Grouping dropdown in the gui, can that help me do multi-series? If so, is there some documentations on that?

Many thanks
Joyce

Like this?

x-multi-series-gui

Oh, that is great, thank you for the screen shot animation!

1 Like