Calculating Score Domo with Variable

Reply
Highlighted
Yellow Belt

Calculating Score Domo with Variable

Hi,

 

I am trying to calculate a score from different fields using CASE in domo but it seems we cannot use variables in beastmode and I am facing dificulties.

Each of my columns have values which I want to translate into a score and then sum up the final score for a line. 

ie: If Field1='1" Then score=20 + If Field2="Yes" Then score=30

In the case above Score returned should be 20+30=50

 

As I cannot create a variable in which I add in the score for each field/column I am not sure how I can past this. 

 

Any help would be very much appreciated. 

Thanks


Accepted Solutions
Major Brown Belt

Re: Calculating Score Domo with Variable

Try adding multiple CASE statements together Something like

 

(CASE

WHEN `Field1` = 1 THEN 20

WHEN `Field 1` = X THEN Y

...etc

 

ELSE 0

END)

 

+

 

(CASE

WHEN `Field2` = 'Yes' THEN 30

ELSE 0

END)



**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Yellow Belt

Re: Calculating Score Domo with Variable

Great thanks this works!

View solution in original post


All Replies
Major Brown Belt

Re: Calculating Score Domo with Variable

Try adding multiple CASE statements together Something like

 

(CASE

WHEN `Field1` = 1 THEN 20

WHEN `Field 1` = X THEN Y

...etc

 

ELSE 0

END)

 

+

 

(CASE

WHEN `Field2` = 'Yes' THEN 30

ELSE 0

END)



**Make sure to like any users posts that helped you and accept the ones who solved your issue.**

View solution in original post

Yellow Belt

Re: Calculating Score Domo with Variable

Great thanks this works!

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!