grouped / stacked bar graph

[#1]

Hi All

I want to create a bar graph where part of the chart is grouped where the other parts is not.  Is that possible?

In this example, I wanted to show the Tickets Created as one bar but I want to group / stack Closed and Canceled/Rejected into another bar so I end up with just bars and not 3.

Thanks

[sivarajs]

Go to expression tab and there is one button like Group thereyou can group your expression

Sivaraj S

[adhudson · Accepted solution]

Hi,

     Please find the attached sample qvw.

     Here, as per your requirement, tickets cancelled or rejected are grouped into one bar where tickets created is as another bar.

     I have created a flag to differentiate between tickets created and tickets cancelled / rejected.

     It has been used in as a secondary dimensionin the bar chart.

     Hope this helps.

Regards

Andrew Hudson

[#4]

Thanks, that solved my question.

[#5]

There is a $syn table created because of two common fields (Date and Flag) between the two tables. Is it required to have two common fields? Because I tried with only one column...'Flag' it didn't work.

[adhudson]

Obviously, It is not mandatory to have synthetic table there. For the sake of simplicity/because of laziness, I have left it I think.

But you can also concatenate those two tables and make it into one. Given that inside this attachment.