Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
In this instance - The time frame was three months to Avg the data which was selected by a list box
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))
Thank you so much for your quick response that is exactly what I needed.
I am glad it helped.