-
Beast Mode to replace null with 0
Hi, I have a pivot table that counts the "EventID" for each row of data, per person. Some people did not have activity so there is not a row of data to count. I tried doing a beast mode for the "Values" field of the pivot table that replaces the null cells with a "0" so I can have the color settings make the cell dark red,…
-
How to view the status of the "prevent drilling to final data grid" checkbox for multiple cards
Is there a way to view the status of the "prevent drilling to final data grid" checkbox for multiple cards at once? I was hoping to see a column for it under the card governance table, but no luck. Thanks!
-
Split string column into multiple rows
Hi, I have a column that has anywhere from 0 to 25 notes in one cell. The delimiter for the cell is a line break after each note. I need to split the cell into a row for each note so that we can filter for just notes that just apply to a group like "Billing" or "Admin". How can this be accomplished? We would like the…
-
Max number of columns in a dataset?
Hi, What is the maximum count of columns for a dataset? Thanks!
-
Override axis date for chart with 2 different date fields
Hi, I am trying to make a chart that shows how many orders were opened and how many were closed per month on the same chart. Orders that have been opened and closed should show twice on the chart. Once in the month they opened & once in the month they closed. The dataset looks like this, where the open and closed dates…
-
Percentage shifts when chart is filtered
Hi, I am trying to make a card that shows the percentage of a client's total business is sent to us ("Company A"). I am using a beast mode and it works well until I try to apply a quick filter to look at clients that are over a certain percentage or filter by one Client. In one instance the percentage goes from 2%…
-
Budget Amount and Gauge Card Setup
Hi, We have 4 sales regions, each with a different budget amount. I want to replicate a report in Tableau that has dials showing how much each region has used of their budget month to date and a Total one showing them all combined. Each row of the dataset details an expense for a labeled region. The budget amounts are not…
-
Beastmode with adjustable date & null filter
Hi, I am recreating a SQL query as a card in Domo. I need it to show transactions where: the OrderDate is before a specific date (that changes each time the report is run) and the SoldDate is NULL OR the SoldDate is after a certain date Is it possible to make a Beastmode that can do this and show an adjustable date filter…
-
Percent of total by month in Pivot table
Hi, I have a pivot table card that shows the units and $ for products sold each month. How do I show the percent of the total $ that product is for that month or the total column? (see highlighted below). Rows: Region, Product Columns: SoldDate Values: SUM of Units, SUM of Price Thanks, Angela
-
Business days in Date_Add Interval
Hi, I have a Beast Mode that calculates the estimated finish date of a process, depending on its type (new or renewal) and if it was started before or after 3 PM. My Beast Mode does this for calendar days, but I need the interval to be business days. We have a separate date table that flags each day for the next 5 years…
-
Summary number for non-distinct rows
Hi, We have 4 sales regions & each has a budget amount. I need to do a summary number that uses the sum of those 4 budgets. 2 regions have the same budget amount so COUNT(DISTINCT) won't work. Each row of the dataset details an expense for a labeled region and that row also contains that region's budget amount (I joined…
-
Round to Millions in Column
Hi, I want to round currency to millions ("$1,500,000" becomes "$1.5M") for a column in a table that I am replicating from Tableau. The results in Tableau look to have just shifted the decimal point instead of rounding. Below I show regular rounding in blue and the Tableau results in green. Can someone advise how I can do…
-
Bucket Series for 100% Stacked Bar Chart
Hi, I have a 100% stacked bar chart for sales that has about 350 options in the series `Company Name`. The units are the number of sales so: count(`Sale Amount`) I would like to bucket the companies that make up 1% or less of the total amount to simplify the legend. There is not a "limit rows" option for this type of…
-
Legend Sort on Bar Chart
Hi, I have a bar chart where I want the legend to be sorted by the highest total units (from all the y-axis currently shown). Currently, it sorts off of the highest units in one particular client, but I want the legend to show the company with the highest total units on that view at the top. I have circled in red the ideal…
-
Nested IF AND for Columns in a Pivot Table
Hi, I have an IF AND nested Excel formula I am trying to recreate in Domo. I want to create a new calculated field that classifies the order submission activity for the prior whole 7 months. This is what the result would look like for each of the options. Assume that May just started so we are just counting October through…
-
Prohibit export or printing of certain cards or pages
Hi, We have a few cards with tables that we do not want to be exported or printed by one "Group" but should be exportable/printed by another "Group". Currently, people in both Groups have the role of "Participant". Below is a chart showing the different scenarios of where would like to prohibit that function for the one…
-
Cards for "Today" go blank at UTC time, not local time
I need the Dojo collective mind! I have a card that shows KPI for only "Today". At 5 PM Pacific time the card goes blank (as if it thinks the day is over). I am physically in the Pacific time zone and all of our date/time data going into Domo is in Pacific time. I have since learned that Domo assumes all data coming in is…
-
Summary Number with 2 metrics needing commas and rounding
Hi, I am trying to make a Summary Number for a card with a calculated field that will look like this: 1,121 Loans | $211,100,123 or even better, if possible: 1,121 Loans | $211.1M The first number could be anywhere from 5 to 500,000. The second currency number could be anywhere from $10,000 to $1 Billion dollars. My…
-
Clickable email link to Beast Mode field
Hi, I want to make a clickable email in a table. The email field is a formula, however, and I can't get the formula to validate. The email field I want to be clickable is "PrimaryContactEmail". Formula for PrimaryContactEmail: Case When Length(`ProcessorEmail`) = 0 Then `OfficerEmail` Else `ProcessorEmail` End I tried to…