Jump to content
Software FX Community
jlancaster

Help with out-chart series

Recommended Posts

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...