Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I make a simple stacked bargraph with below data?
X axis is Equipment.
Y axis is stacked Totals of WR and WO
Total | Equipment | Type |
6 | T5 | WR |
2 | T6 | WR |
2 | T7 | WR |
6 | T8 | WR |
6 | T9 | WR |
6 | T10 | WR |
6 | T11 | WR |
6 | T12 | WR |
6 | T13 | WR |
6 | T14 | WR |
6 | T15 | WR |
6 | T16 | WR |
6 | T5 | WR |
1 | T6 | WR |
6 | T7 | WR |
6 | T8 | WR |
6 | T9 | WR |
6 | T10 | WR |
6 | T11 | WR |
6 | T12 | WR |
6 | T13 | WR |
6 | T14 | WR |
6 | T15 | WR |
6 | T16 | WR |
6 | T5 | WO |
6 | T6 | WO |
6 | T7 | WO |
6 | T8 | WO |
6 | T9 | WO |
6 | T10 | WO |
2 | T7 | WO |
6 | T8 | WO |
6 | T9 | WO |
2 | T10 | WO |
6 | T11 | WO |
6 | T12 | WO |
1 | T13 | WO |
2 | T14 | WO |
1 | T7 | WO |
see attached.
Create a Bar Chart
Add Equipment and Type as Dimensions
Expression is Total
and in the style tab choose Stacked radio button
see attached.
Create a Bar Chart
Add Equipment and Type as Dimensions
Expression is Total
and in the style tab choose Stacked radio button
This worked.
Now I am trying to add an additional trend line by Equipment only (another column not shown). But when I add a second expression for the trend line, I lose the stacked bar feature.
can you attach the file of what you have
I need to add additional trend line showing FAIL count, by Equipment.
When I add this second expression, I lose the stacked bar feature.
Total
Equipment
Type
Result
6
T5
WR
Fail
2
T6
WR
2
T7
WR
Fail
6
T8
WR
6
T9
WR
6
T10
WR
6
T11
WR
Fail
6
T12
WR
Fail
6
T13
WR
Fail
6
T14
WR
Fail
6
T15
WR
Fail
6
T16
WR
Fail
6
T5
WR
Fail
1
T6
WR
Fail
6
T7
WR
6
T8
WR
6
T9
WR
6
T10
WR
6
T11
WR
6
T12
WR
Fail
6
T13
WR
6
T14
WR
6
T15
WR
6
T16
WR
6
T5
WO
Fail
6
T6
WO
Fail
6
T7
WO
Fail
6
T8
WO
Fail
6
T9
WO
Fail
6
T10
WO
2
T7
WO
6
T8
WO
6
T9
WO
2
T10
WO
Fail
6
T11
WO
Fail
6
T12
WO
Fail
1
T13
WO
Fail
2
T14
WO
Fail
1
T7
WO
I am not sure you can add a trendline and keep the stacked bar Chart.
You can have Combo charts like this, but I am not sure about stacked bars with trendline.
Sorry!
According to your “Plant Operations” QVW file it is, but I can’t reproduce this on my relatively simple example dataset.
See the dashboard page. If I changed the graph styles to stacked bar with trend, it stacks and keeps the trend line also.
From: Bogart, Susan
Sent: Monday, October 14, 2013 3:56 PM
To: 'jive-1802381019-2yh8-2-8p9f@qliktech-public.hosted.jivesoftware.com'
Subject: RE: - Simple stacked bargraph
According to your “Plant Operations” QVW file it is, but I can’t reproduce this on my relatively simple example dataset.
See the dashboard page. If I changed the graph styles to stacked bar with trend, it stacks and keeps the trend line also.