Distinct Count Issue

[mhmmd_srf]

Hi All,

In one line my requirement is I want to get something like this:

Count (*)

from

(select distinct OrderNumber,OrderLine

from Table);

If you check above pic. I have Two Order no : 042115 and 042116.

For 042115, the distinct count OrderLine = 3 and

for 042116, the distinct count OrderLine = 2.

So in count I need 3+2. and I want plot only this count in Separate Bar Chart.

Could anyone please help me to get this.

Thanks,

Sarif

[avinashelite]

Add a expression like

count(DISTINCT AHPLotID) that should work for you

[mhmmd_srf]

No Avinash... it will give me 8. Not 5.

[avinashelite]

remove the AHPLotID column

[mhmmd_srf]

Hi Avinash,

I need this in single KPI, like Text Box. So I guess we need to handle in expression.

Please help.

Thanks,

Sarif

[Anil_Babu_Samineni]

May be this?

Aggr(Count(DISTINCT OrderLine), OrderNumber)

[avinashelite]

share the sample app let me check your data set and get back to you

[mhmmd_srf]

Hello Anil,

This is not returning anything.

Please help.

Thanks,

Sarif

[vishsaggi]

Try this in text box may be?

= Sum(Aggr(Count(Distinct OrderLine), OrderNo))

[Anil_Babu_Samineni]

Check this then

Sum(Aggr(Count(Distinct OrderLine), OrderNumber))

Re: Distinct Count Issue