count month

[Anonymous]

hi,

i want to make expression that calculte "Monthly percentage orders".

but when i write "=count(DISTINCT(yearmonth))" , i get only the peirod that have orders.

for exm.

aaa order in feb & april , whan i chose month jan-may ( 5 month) ,

i need to culculte 2/5= 40%.

how do i count month without consider the dimension ?

thanks'

yarin.

[sunny_talwar]

how do i count month without consider the dimension ?

Try this:

=Count(DISTINCT TOTAL yearmonth)

[sunny_talwar]

And to calculate the percentage, try this:

=Count(DISTINCT yearmonth)/Count(DISTINCT TOTAL yearmonth)

[Anonymous]

thanks'

but it's look the same.

distinct total does't work as i need.

[sunny_talwar]

Can you share the some sample data with expected output?

[SreeniJD]

Hi Yarin,

Set an Order flag =1 for order month and 0 for missed month, and use the below expression..

=Sum({<OrderFlag={1}>} 1) / (Sum({<OrderFlag={1}>} 1)+sum({<OrderFlag={0}>} 1))

There is always better ways to do this

HTH,

Sreeni