HELP CENTER

HELP CENTER

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Dojo
- :
- Using Domo
- :
- Beast Mode, ETL/Dataflow
- :
- Calculating Score Domo with Variable

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-29-2019
08:14 PM

05-29-2019
08:14 PM

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-30-2019
05:40 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-30-2019
05:56 PM

All Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-30-2019
05:40 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

05-30-2019
05:56 PM

Announcements