-
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!
-
Drill Path error
Hello, need help if anyone knows the reason what could be the reason for this error message: I am using drill path and this is the visualization I want to make: This is what drill path in my DOMO looks like: For Reports 1 and 2 - I use the same dataset which is "View of loss" For Report 3 I changed the dataset and used…
-
Drillpath to an existing card
Hello, is there a way to drillpath to an existing card using beastmode or any other domo features that might work? Thank you!
-
How get and combined column from another dataset using magicETL
Dataset A columns: Name, Bday, Age, Gender, City Address, Country Dataset B columns: Name, Position, Salary, Company columns I only want and will name as DatasetC: Name, Bday, Age, Position, Salary I am thinking if I can just use Dataset B, save as Dataset C and add columns (Name, Bday, Age) from Dataset A. But I don't…
-
Dynamic Date in card tittle
The objective is to add max date of "open date" column in the card tittle. For example: Open date max date is 11/22/2024 My card tittle will be: "Opened Account as of 11/22/2024" I am thinking to use beastmode and create a calculated field with "max(open date)" but when I'm using smart text function in the tittle to add…
-
Arrangement in Bar Graph
Hello, is there a way to rearrange the order of legend in Bar Graph? My card looks like this: Tr - bottom Ac - middle Ro - Top I want to rearrange the order like this: Ro - Bottom Ac - Middle Tr - Top Thank you.
-
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!
-
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…
