jlancaster Posted October 25, 2010 Report Posted October 25, 2010 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 Quote
Recommended Posts
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.