I have 2 different queries that return the same table fields: allow and block, but with the values of each query.
The returned series have the same name. I don’t know how to name them after the query name (I don’t know if this has any importance for the final goal)
I want to build a stacked bar chart like:
each bar is a query, and allow and block values are stacked for each bar.
I have been trying to do some transformations so my data ends as needed for stacking
query/utmaction | allow | block |
---|---|---|
countapp | 100 | 10 |
countweb | 200 | 20 |
but had no success yet.