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,631
  • UX
6 REPLIES 6
Top Labels in this Space