Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Count((MsgType)=(census)) as you know this does not work.
My field has 5 different values I am creating a table to display Facility month year and Census, Newrx, and three other.
How do I count only one of the five in each column?
It should be as below:
Count( {<MsgType={'census'}>} census)
Count( {<MsgType={'Newrx'}>} Newrx)
This is what I have but it only counts 1
Count( {<MsgType={'NEWRX'}>} 'NEWRX')
I don't have any data to tell you what is wrong... Can you please upload a sample app with expected output so that we can take a look.
Note: You have extra quotes at the end, so remove them. It should be as below:
Count( {<MsgType={'NEWRX'}>} FieldName)
Try this:
Without quotes for the field name and is your field name all capitals or like this Newrx ?
Count( {< MsgType = { 'NEWRX' } >} Newrx)
How about this:
Count({<MsgType={'NEWRX'}>} MsgType)
Send a qvw example
My bad, Thanks for catching this Sunny.
RObert please use sunny's expression. It should work.
Did you try this?
Count({<MsgType={'NEWRX'}>} MsgType)