Distinct Total Count in Statistics Box

[harleen_singh]

Hello,

I want to know how to Display Distinct count in Statistics Box in place of 'Total Count' function.

Total Count function always count all the rows but i want to count only Distinct values.

Thanks

Lavi

[#2]

Hello Lavi,

had the same demand a few weeks ago, but I didn't find any resolution. The availible functions are hard wired and thats it. But perhaps this little workaround will help you: I used the help text to show the count distinct through an expression.

Regards, Roland

[harleen_singh]

Roland,

thanks for ur response. Well can u tell me where is this help text?? Is it inside statistics box or in other place?

Regards

Lavi

[#4 · Accepted solution]

Hi Lavi,

no problem. Go to Statistics Box properties --> Caption Tab --> in the lower right corner you will find help text inputfield. My field is called VQuartal:

='VQuartal dist.: ' & count(distinct VQuartal)

RR

[Anonymous]

Hi Roland,

          I tried your idea and it worked successfully. I have attached screen shot also. But, is there any way to get into the Statistics Box witout getting the information into "HELP" properties of Statistics Box. Please Help me. Thanks in advance.

[#6]

Hi there

it doesnt work with me ? could you please help here is a sample from the field data

CMKJ19

CVTN03

CWLV03

CWZR17

CXZH06

CZSM05

DBGQ09

DBVT09

DBSS06

DCGH19

DCPN06

DCTV06

DGRL19

[josephinetedesc]

I found I needed to use a text box to do a distinct count  ...

[#8]

But i ve tried that as well same results

[josephinetedesc]

Hi Eman

this might help.

Because (infoWanted) is a text field then all the other statistical values are n/a

so Text count and Total count are ok - I am not sure what Missing count means.

the text box has:

=count(Distinct(infoWanted)) & ' this is the count of distinct ....'

Jo

[#10]

Thank You so much Jo i got it now.

Appreciate your help.

Thanks

Eman