This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looker Studio Scorecard

Posted on 06-20-2024 04:31 AM
Prachee
New Member
Reply posted on --/--/---- --:-- AM

Getting wrong conversion ratio from two scorecards- Won and Lost. Won=49 and Lost=64 then correct answer is 43% but getting 59%

0 4 316
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
ArkadyZagdan
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

Hey @Prachee 
Can you please elaborate more?
How the data source looks like? What formula you are using?
Are you using SUM(z)/SUM(y) or just z/y? 

0 Likes

Posted on --/--/---- --:-- AM
Prachee
New Member
Reply posted on --/--/---- --:-- AM

Tried both ways Sum and without sum answer is same. But real calculation is won/(won+lost) . Tried this also.

0 Likes

Posted on --/--/---- --:-- AM
ArkadyZagdan
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

Hard to troubleshoot without a glance at your data source and formulas you are using.

0 Likes

Posted on --/--/---- --:-- AM
lauratilton
Silver 4
Silver 4
Reply posted on --/--/---- --:-- AM

How about using COUNT or COUNT_DISTINCT instead of SUM? What are the fields you have to work with? It’s not clear what you’re summing.