Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need to know for what Year the maximum number of calls are received from Active type over the years in a textbox.(Excluded the year filter so i have put "Year=")
I am using the following expression.
=max(Aggr(Count({<TYPE={'Active'},Year=>} Call_ID ),Reason,Year)).
With this my result in 29813.
Individually for Year
2015 - 29813,
2014-32994,
2013- 27661,
2012 - 13343,
2011-7232
when i do the above expression the result should be 32994.
What is wrong with the expression??
Hi Nithin,
Try this:
=max({1<Year=>}Aggr(Count({1< COVERAGE_TYPE={'Active'}>}Call_Log_ID),CallReason,Year))
double check the syntax in the editor because I've not been able to.
Cheers
May be you need a DISTINCT count?
=Max(Aggr(Count(DISTINCT{<TYPE={'Active'},Year=>} Call_ID ),Reason,Year)).
Nope, didn't work.
I have selected 2015, But for some reason year filter is not being Excluded.
Would you be able to share a sample?
I can't share nothing more than this as data is confidential.
I need to retrieve the highest value of all the charts using an Aggr() in a textbox.
Hi,
Why do you need to aggregate on the field 'Reason'? If you take it out to leave
=max(Aggr(Count({<TYPE={'Active'},Year=>} Call_ID ),Year))
what is the answer then?
In 2014 if you have 29813 Active type call of reason A and 3181 for reason B (total 32994) your Aggr expression will return 29813.
Hi Andrew,
Please refer to the above image. i need Highest number of calls for any reason over all the years. it is working fine if i don't select an year. but if i select an year it is limiting to the that Year.
That is the challenge am facing.
Hi Nithin,
Try this:
=max({1<Year=>}Aggr(Count({1< COVERAGE_TYPE={'Active'}>}Call_Log_ID),CallReason,Year))
double check the syntax in the editor because I've not been able to.
Cheers
Thanks Andrew, It worked.
You're very welcome!