How can I divide column expenses by column total leads? I try (expenses / total leads) but it won't work.
Hi @Aliaksei, thanks for your post!
It looks like Total leads is a metric (an aggregated value) and Expenses is a dimension (a non-aggregated field). You can't perform calculations between a field that is an aggregated value and a field that is a non-aggregated value.
As. workaround you can try making Expenses a metric and then dividing the two fields, as described in this Reddit post.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |