Jump to content
Software FX Community

jlancaster

Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by jlancaster

  1. 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

×
×
  • Create New...