Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Area chart - only specific values

Hi all,   new problem for me.   i've got an sql data source wich is reporting the dates and if there is an violation of a ticket.   Now I want to plot this on an Area chart, x-axis is the date ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    You just add the sum(violation) as value, and date as x-axis level. Please see the following screenshot.



    You can download the attachment to check more details.

    Best Regards,
    Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

thanks for your answer, maybe I was a bit unclear.

 

If there was an SLA violation the table gets a 1, otherwise (no violation) will get an 0.

But there could be more dan 1 violation per day (if there are 5 tickets, maybe 3 gets the violation)

 

So I want to view every day in the chart, even if there aren't any violations, if there are violations I want to see how many.

 

It possible that on day 1 only 1 violation is, day 2 5 violations, day 3 0violations, day4 3violations.

 

THanks

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

You just add the sum(violation) as value, and date as x-axis level. Please see the following screenshot.



You can download the attachment to check more details.

Best Regards,
Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    YES! this solves my issue.

     

    Thanks!

     

    Joris