Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
in dimension Month
measure count(Number of loans)
?
if I understand correctly
@Poonamkumari if I understood correctly use Set analysis like count( {<Month={..}>}MEASURE)
if not you can share a sample data and the expected output
Hi @Taoufiq_Zarra thanks for reply
I have attached a sample records, I want to show count of records per month .
in dimension Month
measure count(Number of loans)
?
if I understand correctly
measure count(Number of loans) not giving what is expected.
attached expected output.
in dimension Month
in measure count([Number of loans])
not working ?
this is the output from your sample:
@Taoufiq_Zarra Thank you for the help, it worked 🙂