cancel
Showing results for 
Search instead for 
Did you mean: 

How to count distinct values IN a month not across entire table.

How to count distinct values IN a month not across entire table.

Right now I have a transaction table that contains transactions. I want to know by month, how many people in each month have at least 1 transaction.


Doesn't seem possible in RJ.  For example, when I setup the metric I get:

This metric performs a

  • user_id

 column in the transaction table (Changeordered by the

1 REPLY

Re: How to count distinct values IN a month not across entire table.

Hi there -

 

The configuration of the metric and report from the description you provided both sound correct. We would expect this report to count the number of distinct users making transactions in each month separately. So, if user A made a transaction in Jan 2017 as well as Feb 2017, they would be counted in both months as long as the time interval on the report is set to "By Month".

 

Would it be possible to share a screenshot of the metric and report configurations being used? Please also feel free to reach out to support@rjmetrics.com, and we can help answer your question!

 

Thanks,

Akash Agrawal

Senior Analyst, Magento Business Intelligence