Explore is rounding a number when dividing
AnsweredI have 2 metrics on Explore which are showing two numbers for example:
Metric A Metric B
102 153
Now I need to divide Metric A with Metric B so I used Result Metric Calculation and added a new metric to divide the two numbers. Therefore Metric C is SUM(A) / SUM (B). The result should be 0.67 but on Explore the result is 1. When I tested out SUM (B) / SUM (A) the result is 2 which should be 1.5. So the question is,
Is there something that is making the number to round up?

Hi Carl,
There are two ways to fix this.
1. Multiply your result by 100 (if you're looking for a percentage)
2. Go into Chart Configuration > Display Format > and from here you can change the Display Format to "Custom" with two decimal places.
 Andrew
Please sign in to leave a comment.
1 Comments