Help for needed chart

[#1]

Hi all,

I need to create a stacked bar chart with customer name as the dimension.  I want to show the number of open defects per customer based on the severity level.  I know this is set analysis, but I'm not sure how to do this with 3 variables:

Defect type = Defect

Severity = 0 or 1 or 2 or 3

Status = OPEN

Here is the excel version:

All help and guidance is much appreciated!

[vishsaggi]

Can you share some sample data to work on?

[sudeepkm · Accepted solution]

you can create a bar chart and then

Select [Customer Name] as first dimension and Severity as Second

Then add expression: count({< Status={'Open'}, [Defect type] = {'Defect'}>}defect_id)

Select your bar chart style as Stacked.

I've assumed the field names but you can use your actual field names in your app.

[#4]

Sorry, disregard the previous dataset.....

[sudeepkm]

here is one way you can create your chart. PFA.

[#6]

I have the chart created, however, can you tell me how to show the defect counts as ascending?  The only way I can see to sort is by company or severity.

[vishsaggi]

Use this count expression in your Sort tab sort by Expression Check box then write this Count expr and change it to ascending.

[#8]

Of course...thank you!

Thanks to all for the excellent help...problem solved!