Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table 'users' with fields: [user_id], [login], [user_date_register]...
Also i have table 'transactions' with fields: [transaction_id], [user_id], [transaction_date], [sum] ...
I need to make report as:
Date | Count_of_users | Count_of_transactions | Count_of_users/Count_of_transactions |
---|---|---|---|
.... | ... | ... | ... |
How i may make it?
Hi
if the main date is the transaction_date do like this:
users:
Load [user_id],
[login],
[user_date_register],
...
from ....
transactions:
load [transaction_id],
[user_id],
[transaction_date] as Date,
[sum]
from ....
then in the chart put in the dimension Date
and in the expression put:
count([user_id]) as count_of_users
count([transaction_id]) as count_of_transactions
count([user_id])/count([transaction_id])
BR
Ariel
Date in this report is common for transactions and user registrations. I need calculate count of users on service per date and count of transactions in this date.
sample of table 'users':
user_id | login | user_date_register |
---|---|---|
1 | hh | 01-01-2012 |
2 | tt | 01-02-2012 |
3 | pp | 01-02-2012 |
4 | oo | 01-03-2012 |
sample of table 'transactions'
transaction_id | user_id | transaction_date | sum |
---|---|---|---|
1 | 1 | 01-01-2012 | 20 |
2 | 1 | 01-01-2012 | 30 |
3 | 2 | 01-02-2012 | 15 |
4 | 1 | 01-02-2012 | 15 |
5 | 3 | 01-02-2012 | 6 |
6 | 4 | 01-03-2012 | 23 |
7 | 4 | 01-03-2012 | 14 |
8 | 2 | 01-03-2012 | 18 |
than report is
Date | Count_if_users | Count_of_transactions | Count_of_transactions/Count_if_users |
---|---|---|---|
01-01-2012 | 1 | 2 | 2 |
01-02-2012 | 3 | 3 | 1 |
01-03-2012 | 4 | 3 | 0,75 |
Hey to solve a similar problem i used the approch that you can find in this QVW.
See attached file
I don't see attached files. Can you send it to me (inter-proger@yandex.ru) or post it here again?