Chart Expression

[#1]

Hello Everyone,

     As in following Chart for Jan column i need to show for ex (1323/3421) for critical Request and (2168/3491) for Grievance,count 1323 i am getting from count(callid) ,callid is unique field .In case of more clarification please reply.

    

[its_anandrjs]

You can try

count(callid) / count(TOTAL callid)

And how comes 3421

[#3]

=count(callid) & '/' & count(total callid)

[#4]

hi anand ,

     3421 is total of callid for Jan month for critical request and grievance as shown in image

and count(callid) / count(TOTAL callid) is giving 0.039 where as it should come 1323/3421 =0.38,, count (total callid)

is giving me total count 33413 not the total count for month Jan 3421?

[#5]

count(callid) / count(TOTAL callid) is giving 0.039 where as it should come 1323/3421 =0.38,, count (total callid)

is giving me total count 33413 not the total count for month Jan 3421?

[#6]

guys kindly reply.

[PradeepReddy]

can you please attach the sample .qvw file?. So that it will be easy to understand the issue.

[johanlindell · Accepted solution]

Hi,

You need to state the field in which to do the Total. I'm a bit unsure bot is should either be

count(callid) / count(TOTAL <CallCategory> callid)

or

count(callid) / count(TOTAL <Month> callid)

Try it and you will find which it is.

If you do not state which field to sum on, you will get the sum of acc CallCategories and all Months.

Brgds, Johan

[#9]

Hi johan

     Thank you soo much its working i needed to do total for Month field.Thanx

[johanlindell]

Hi Robit!

Good that works. Please set the thread to answered.

Johan