Jump to content
Software FX Community
jlancaster

Help with out-chart series

Recommended Posts

jlancaster    0

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×