Explore is rounding a number when dividing
RéponduI 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
Vous devez vous connecter pour laisser un commentaire.
1 Commentaires