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

[rjuser3]

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

• Count Distinct Values

 on the

• user_id

 column in the transaction table (Change) ordered by the

• transaction_date (UTC)

 column.

If I then create this metric and plot it by month. I am only actually getting users that created a transaction for the first time in the months. Any user that had a transaction each month isn't counted again and again.

Doing a count of all rows, and trying to GROUP BY user_id also fails.

How do I fix this?

[akash_agrawal]

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