How do I create a stacked bar graph with 2 fields?

[jhoang]

Hi,

I am trying to create a stacked bar graph, using 2 fields.

First field is Level, second field is Urgency. I want to sort the columns based on Level, and displaying the number of different Urgency in the stacked column. See below, the long column would show 2 critical items, 1 high, and 1 medium items, for a total of 4 items.

Level Urgency
Long Critical
Long Critical
Long High
Long Medium
Medium High
Medium Low
Medium Low
Medium Low

[somesoni2 · Accepted solution]

Try something like this

your search giving above output (two fields) | chart count over Level by Urgency

Select the appropriate option in the visualization to create stacked chart.

[jhoang]

Thank you brother!!!!

[arbelron3]

hey,
I tried and I dont get a graph for each Urgency but a seperated values... it erases some of the points... does someone know why and how I correct it ?

[jhoang]

Note - this is for year to date data. Is it possible to display this without using the timechart option ?