Count

[noman212]

Hi friends,

i have a date field, from which i made month ... like jan, feb , mar..

Now i want to calculate the count of these month in Month(Date) fieled.

For Example.

In Month field i have JAN,FEB, MARCH.

I want Count of these month as 3 . Simple count is not working.

[tresesco]

Count( Distinct YourMonthField)

[PrashantSangle]

Hi,

What is your expression?

Count(distinct Month) should work if want count of distinct Month

or

Count(Month) gives count of all month

Regards

[#4]

Hello,

I am not sure I understand your question. do u want to do a distinct count of the values in the Month field? do wish to do this is a script or a chart? what does the count you have created returns?

Nir

[ashfaq_haseeb]

Hi,

use distinct keyword.

Regards

ASHFAQ

[jagan · Accepted solution]

Hi,

Try using Count() and Distinct

Count( Distinct MonthDimensionName)

Regards,

Jagan.

[noman212]

Its display count for whole year i want listed month count , in  my qvd i have only 3 months records.

[ashfaq_haseeb]

Can you post sample

Count( Distinct [Yourmonthfield]) must work.

Regards

ASHFAQ

[noman212]

Its Work fine Thanks alot

[noman212]

Thanks again jagan mohan