I have a requirement to display the following in a bar chart.
1. Open Tickets
2. Closed tickets
3. Open tickets for department A
4. Closed tickets for department A
The bar chart should have two bars " Open ticket and Closed ticket" being displayed for a single dimension "Month" but the bars should be stacked and display 'Open tickets for department A' and 'Closed tickets for department A' in the respective two bars itself.
Looking for a solution to this problem. Is it feasible?
Solved! Go to Solution.
Won't be able to attach the data/qvw but attaching a snapshot of how the bar chart looks for the four expressions. (Snip.jpg)
The data for 'Dept A Open' and 'Dept A Closed' is a subset of the entire data set for 'Open tickets' and 'Closed tickets' respectively.
The objective is to try and show the subsets in a pair of bars for the 'Open tickets' and 'Closed tickets' (Snip2.jpg) as a stacked bar chart generally looks like
I had a look at your expressions in the qvw.
The value of Sum(DeptAOpen) and sum(DeptAClosed) should be speparately visible in the same two bars of the graph- “All Open” and “All Closed” but with a different colour so that they can be identified.