Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Is it possible to create a Stack chart using aggregate (group / count) of columns?

Hi, is it possible to create a Stack chart using aggregate (group / count) of columns?

Selecting Horizontal Histogram I have then the option to group aggregate via Count:
2X_2_29af088a177e33597b6420c5aab58075ae3cfd73.png

However, when selecting Row Series (Stack) chart type, there is no option to Group Aggregate. Furthermore, I can not see any of my columns in the drop-down…
2X_9_9d2f7c6b83dbae4f0daa6166292e164ca6a531d8.png

I want to create this horizontal bars chart of Abandonments by month, but Stacked: i.e. composed of Justified (green) and Not Justified (red) abandonments.
2X_f_f3be54ad98a2dd65722d2e8375fff23aca0043ab.png

I tried creating some helper columns in the google sheet to follow the example of Stacked Chart of the manual, however could not include them in the Row Series Stack chart above because it would not show any of my columns in the dropdown…
2X_e_e2a36721993b918f1572d1c48386b584d340c1aa.png

Help!

thanks

0 6 1,948
  • UX
6 REPLIES 6
Top Labels in this Space