Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I m using two stack bar chart.
1 stack bar chart and 2 stack bar chart: have different dimension and expression
Now i want to these two stack bar chart has to be in one bar chart and they should show the two different stack bar
first stack chart show the count of dept wise
dept wise
below is the data
Dept | Count |
IT | 100 |
CSE | 200 |
EEE | 300 |
second stack bar shows count of male and female
Person | Count of Person |
Male | 1000 |
Female | 2000 |
Hello - I would recommend that you keep the two charts separate, as they represent different dimensions and expressions.
You might consider placing them in a container object with "Grid" Style selected on the presentations tab.. This way you can visualize each side-by-side and with similar sizing.
these two stack bar has to be in one chart
not correct answer
My previous reply was not answer, it was just to tell the details provided by you are not clear.
That's fine. Let's circle back to your question.
You can create cyclic dimension group and based on the active field in cyclic group you can change the expression.
Same object for two different sets of Dimension and Metric.
It might work if you transform the tables in the attached format, but with some trade offs.
Hi,
not very nice, but seems to work (sort of) without changing your data model:
hope this helps
regards
Marco