5 Replies Latest reply: Aug 13, 2015 11:00 AM by Liam Do

# Graph shows different values when select a single day

Hi All,

I don't know why my graph behaves the way it is and I hope that you can help me.

Below is my expression:

(Sum(total aggr( if(((Sum (met_sl))/(count(session_id)))>.8, 1,0),half_hr_bucket)))/48

And these are the results for each day from above expression when I select every single day from the selection.

 Date Result 7/1/2015 77% 7/2/2015 67% 7/3/2015 73% 7/4/2015 69% 7/5/2015 63% 7/6/2015 73% 7/7/2015 46% 7/8/2015 56%

I don't know why it does not show above results on graph, instead it shows 58% for all days.

Your inputs are very much appreciated!

Thank you.

• ###### Re: Graph shows different values when select a single day

Hi Liam,

Can u attach qvw file?

Regards,

Partha Kulkarni

• ###### Re: Graph shows different values when select a single day

Try this and see if the result changes:

=(Sum(TOTAL <Date> Aggr(If(((Sum(met_sl))/(Count(session_id)))>.8, 1, 0), half_hr_bucket)))/48

• ###### Re: Graph shows different values when select a single day

Can you share the sample app?

• ###### Re: Graph shows different values when select a single day

You need the Date field in the Aggr() as it is the chart dimension, and I don't think you need the Total (hard to say without a sample):

=Sum(Aggr(If(Sum(met_sl)/Count(session_id) > 0.8, 1, 0), half_hr_bucket, Date)) / 48

Or

=Sum(TOTAL Aggr(If(Sum(met_sl)/Count(session_id) > 0.8, 1, 0), half_hr_bucket, Date)) / 48

• ###### Re: Graph shows different values when select a single day

@Jonathan Dienst: your first expression works! I do not know why the Total is the problem, would you please explain? Thank you.

@All: Thank you very much for your inputs