Average data and minuets in Chart

[kstroupe]

Hello,

I am trying to determine if cell phone usage is LOW for a time frame.  I have a data load which has date, asset_id, data, minuets

In a straight table I was able to accomplished this with the following expression (The date time frame was chosen from a List Box):

=If(Avg(DataMB) <50 and Avg(Minutes) < 60 and status = 'ACTIVE' and Asset_Type = 'SMARTPHONE', 'LOW',If(Avg(DataMB) <50 and status = 'ACTIVE' and Asset_Type = 'IPAD', 'LOW',
If(Avg(Minutes) < 60 and status = 'ACTIVE' and Asset_Type = 'FLIP PHONE', 'LOW','OK')))

Asset_ID	Asset_Type	Both	Data	Min
12747	SMARTPHONE	OK	45	320
5180	SMARTPHONE	OK	2802.333333	863.3333333
8723	SMARTPHONE	LOW	0	0
2348	SMARTPHONE	OK	5105	906.3333333
24892	IPAD	LOW	0	0
0547	IPAD	LOW	0	0
4292	SMARTPHONE	LOW	43	40
0476	FLIP PHONE	LOW	0	0
281	FLIP PHONE	LOW	0	7.666666667
502	FLIP PHONE	OK	0	1292
518	FLIP PHONE	OK	0	247

I would like to create a chart which counts the  "LOW" by Asset_Type

Any suggestions? 

Thanks In Advance

Kim

[kstroupe]

In this instance - The time frame was three months to Avg the data which was selected by a list box

[Digvijay_Singh · Accepted solution]

Something like this -

Count(if(Aggr(

  If(

  Avg(Data) <50 and Avg(Min) < 60 and Status = 'Active' and Asset_Type = 'SMARTPHONE', 'LOW',

  If(Avg(Data) <50 and Status = 'Active' and Asset_Type = 'IPAD', 'LOW',

  If(Avg(Min) < 60 and Status = 'Active' and Asset_Type = 'FLIP PHONE', 'LOW',

  'OK'

  )

  )

  ),Asset_ID,Asset_Type)='LOW',Asset_ID))

[kstroupe]

Thank you so much for your quick response that is exactly what I needed. 

[Digvijay_Singh]

I am glad it helped.