Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need assistance with the following query
We have a table with a single column, field name "Answered" with values True and False
Answered
True
True
False
False
True
We need to count the True values ? I've tried the following but it returns zero.. Not sure what I'm missing?
Count({<Answered={"True"}>} Answered)
Hi,
Trim it and try.
HTH
I've attached my QVF file but it hasn't been approved (moderated)
My data is as such
Call ID | Answered | Date |
121 True 10/10/15
122 True 10/10/15
123 False 10/10/15
124 True 11/10/15
125 False 11/10/15
126 True 12/10/15
Need the following (I can get the total easily =count (Answered) but getting how many calls are answered for a particular day is beyond me.
Date | Total Calls (Count) | Answered (Count)
10/10/15 3 2
11/10/15 2 1
12/10/15 1 1
Count({<Answered={"True"}>} Answered) Returns 0 for each day (Guess Im missing something to do with the date?)
Not sure what you mean. Ive attached my qvf file above for reference. Appreciate your assistance.
I need to see the total count for each day total calls and total answered calls ie. "True"
Maybe my issue is to do with the date . Please refer to my qvf which i posted above
Give this a shot:
Count({$<Answered={'-1'}>} Answered)
It appears that Sense is evaluating the Answered field as a number instead of a string so in this case true=-1, false=0.
Hope this helps.
HI,
Try like this
LOAD
CallID,
Answered,
Date(Floor(Date)) AS Date
FROM DataSource;
Now try below expression
Count({<Answered={"True"}>} Answered)
Hope this helps you.
Regards,
Jagan.
Count({<Answered={'-1'}>} Answered)
This is what u need
Thanks this did it