count number of records month wise

[Poonamkumari]

Hi All,

i want to count number of records month wise.

for Example I have 31 records in November month and 7 records in December Month so i want to count the number of orders month wise.

I have 5 coulumn like Month,Number of order, Value of order, like this. Have attached a SS for what I needed actually 

any help will be appreciated.  

[Taoufiq_Zarra]

@Poonamkumari  if I understood correctly use Set analysis like count( {<Month={..}>}MEASURE)

if not you can share a sample data and the expected output

[Poonamkumari]

Hi @Taoufiq_Zarra thanks for reply 

I have attached a sample records, I want to show count of records per month .

[Taoufiq_Zarra · Accepted solution]

@Poonamkumari 

in dimension Month

measure count(Number of loans)

?

if I understand correctly

[Poonamkumari]

@Taoufiq_Zarra 

measure count(Number of loans)  not giving what is expected.

attached expected output.

[Taoufiq_Zarra]

@Poonamkumari 

in dimension Month

in measure count([Number of loans])

not working ?

this is the output from your sample:

[Poonamkumari]

@Taoufiq_Zarra  Thank you for the help, it worked 🙂