Distinct values

[#1]

Hi,

Could you please resolve the issue

[its_anandrjs]

You can

=Count(DISTINCT flightNo)

or

=Count(flightNo)

[#3]

i cant use count( distinct flightno)

this will count distinct flights of whole month.

but i want that it should calculate distinct flights of day wise not month wise  and i want  to calculate monthly data.

[MK_QSL]

COUNT({<[service used] = {'GPU'}>}flightno)/Count(TOTAL flightno)

[its_anandrjs]

Use pivot table and use this expression for the calculation

=Count(DISTINCT flightNo)

or

=Count(flightNo)

[#6]

according to my table  on 22nd flight B has used two service  but i want to calculate it as one but on 23 rd b has again used two service so i want to count it as 1  and on 24th b has used 1 service so i count as one  so total count should calculate like this . like wise for every flight ..

[MK_QSL]

You are mentioning dates which you haven't given in your sample data.

Can you provide some more data please?

[jonathandienst]

Hi

Assuming you have a table or chart with a month field (month) as a dimension:-

     =Sum(Aggr(Count(Distinct flightno), date, month))

This will count distinct flights on each day in the month.

HTH

Jonathan   

[#9]

Thanks ]