Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Can you share some sample data to work on?
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.
Sorry, disregard the previous dataset.....
here is one way you can create your chart. PFA.
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.
Use this count expression in your Sort tab sort by Expression Check box then write this Count expr and change it to ascending.
Of course...thank you!
Thanks to all for the excellent help...problem solved!