4.3K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

Calculate percentage with a calculated metric in a Report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, recently, I have created some custom metrics to capture some information and I want to use a calculated metric to calculate the percentage of hits (measured variable) with respect to the total amount of users for example. So I made the formula like this:          


Calculated_Metric = (Hit*100) / Users


The problem is that, when it comes to the Users (default variable), it just takes into to account that particular user, and not the whole set of users that I have, so the result is always like this:


Calculated_Metric = (Hit*100) / 1. ie: Calculated_Metric = (3*100) / 1 = 300, and so on...

and I want to calculate: Calculated_Metric = (3*100) / 3 = 100% or 

Calculated_Metric = (1*100) / 3 = 33.33...% (assuming there's just one hit per user) 

Is there a way to make this possible?


Thank you very much in advance. I appreciate any help.