First, I must confess I'm no powershell guru, so please excuse my ignorance. I'm trying to create a stacked bar chart from three columns of data I am getting back from a powershell sql query. I'd like the first column (count of tickets) to be the y-axis, the week # to be the x-axis and the type to be a stacked bar chart. I've read through the documentation but I'm stumped. All of my charts end up with tickets on the y axis and type on the x-axis.
Second, I can find very little in the way of script examples for out-chart. (One of the results I Googled was so virus-laden it nearly took out my computer. So be careful.) Where can I find examples?
My query results come back in this format:
tickets
week
type
113
36
Client Initiated Incident (Reactive)
197
36
Monitoring initiated incident (Preven...
1
36
Non-incident request (Planning)
14
36
Proactive Maintenance (Proactive)
1
36
Server Reactive
16
36
Server Watch Only
109
37
Client Initiated Incident (Reactive)
239
37
Monitoring initiated incident (Preven...
9
37
Proactive Maintenance (Proactive)
1
37
Server Proactive
15
37
Server Watch Only
1
38
141
38
Client Initiated Incident (Reactive)
194
38
Monitoring initiated incident (Preven...
1
38
Non-incident request (Planning)
3
38
Proactive Maintenance (Proactive)
1
38
Server Proactive
23
38
Server Watch Only
158
39
Client Initiated Incident (Reactive)
233
39
Monitoring initiated incident (Preven...
17
39
Proactive Maintenance (Proactive)
1
39
Server Proactive
13
39
Server Watch Only
133
40
Client Initiated Incident (Reactive)
225
40
Monitoring initiated incident (Preven...
2
40
Non-incident request (Planning)
16
40
Proactive Maintenance (Proactive)
1
40
Server Proactive
21
40
Server Watch Only
110
41
Client Initiated Incident (Reactive)
233
41
Monitoring initiated incident (Preven...
1
41
Non-incident request (Planning)
11
41
Proactive Maintenance (Proactive)
35
41
Server Watch Only
74
42
95
42
Client Initiated Incident (Reactive)
136
42
Monitoring initiated incident (Preven...
2
42
Non-incident request (Planning)
3
42
Proactive Maintenance (Proactive)
22
42
Server Watch Only
51
43
123
43
Client Initiated Incident (Reactive)
50
43
Monitoring initiated incident (Preven...
10
43
Non-incident request (Planning)
4
43
Proactive Maintenance (Proactive)
5
43
Server Watch Only
Thanks,
Jim LancasterDallas, TX