-
Remove null values to make sorting works accordingly
Hello, I have a "transaction month" column that can't be sorted accordingly because I have some months with NULL values. When I used sorting ascending/descending my months looks like this: Question, is there a formula that can be used in beastmode or function in domo to correct my sequence by month when I have a NULL…
-
COLUMN to add as ROW.
Our database looks like this: We have separate columns for TransactionType, new_policy and renewal_policy. So when we build the card, the New policy and Renewal Policy won't come under the Transaction type, which we want to visualize like this: Question, How can I add/merge "new_policy_count" and "renewal_policy_count"…
-
Percentage calculation using beastmode
Hello Everyone, Please help. I am getting syntax error when I'm trying to rewrite this formula in beastmode. Below screenshot of my formula how it looks like in our database that I want to re-create using beastmode: I want to get a Loss Ratio percentage between 0 to 100. and results should have a percentage sign with 2…
-
Group By and Drill down
Hi, I am new user of DOMO and need help building this report: I have a data with columns: Name, Age, Birthday, Position, Email, Salary. For initial screen I want a filter channel by Name, Age and birthday. Then allow user to drill down into each Name for Position, Email, Salary details. Thank you!
-
Need to get TOP 10 only
Hi, I build this card using a bar graph and aim to get the TOP 10 PERILS only. What formula in beastmode can I add just to get results for only the top 10? Columns used: "Peril" and "Peril Counts" Thank you!
-
Ratio Formula
Hi! I need help to use the beast mode function. I have the following columns: Name, Ref #, Paid Amount, Savings Amount and Bill Amount. I want to get the Ratio of Each Name using this formula: Paid Amount + Savings Amount / Bill Amount Thank you!
-
Group By/Drill down
Hi, I am new user of DOMO and need help building this card: I have a data with columns: Name, Age, Birthday, Position, Email, Salary. For initial screen I want a filter channel by Name, Age and birthday. Then allow user to drill down into each Name for Position, Email, Salary details. Thank you!
-
Can DOMO support multiple measures in a single report?
Our database looks like this: We have separate columns for TransactionType, new_policy and renewal_policy. This is how the data (columns) in DOMO: So when we build the card, the New policy and Renewal Policy won't come under the Transaction type, which we want to visualize like this: Question is, does DOMO support multiple…
