report - Can I create a Google Data Studio Stacked Column Chart featuring two metrics versus one?

Question

I have been pleased with the ability to produce a simple Google Data Studio Column Report which displays data for each day of a month and two metrics (quantity and commission). These two metrics' columns( vertical bars) are grouped together each day. So, going from left-to-right, day 1 has a quantity and commission vertical column, day 2 has a quantity and commission column, etc. The quantity column is one color, the commission column is another. Each column (quantity and commission) is a specified metric when building the report. It appears numerous metrics are allowed.

I've been asked to provide a little more granularity to each bar (quantity and commission). I'd like to be able to keep the same format I created originally; however, I want to use a stacked column to show the composition of each day's quantity column (personal versus commercial) and each day's commission column (personal versus commercial). When I try to create a stacked column report, I am only allowed ONE metric versus multiple. It seems as though I am going to have to create two separate stacked column reports which I do not want to do as it will take too much screen Real Estate and be wasteful. Is there a work-around available to meet my need? Or, am I simply limited to one metric - period - for a stacked column report?

question from:https://stackoverflow.com/questions/65942593/can-i-create-a-google-data-studio-stacked-column-chart-featuring-two-metrics-ver

Answer 1

Waitting for answers