-
Case When statement
Is it possible to use contains instead of = in the Case When statement CASE when 'Amount'=1 then 10 else 0 End For example: Case when 'Reason' contains 'Retal' then 'Retaliation' Else 'Other' End we have many different variations of Retaliation statements and don't want to spell each one out in a case when statement Fear…
-
How to create a graphic link
Hello, I am trying to create a graphic link that will direct a user in Domo to a specific card in Domo by clicking on the graphic. I was wondering how to create this Thanks
-
Calculating NPS total score based on a survey
Hello, I need to create an NPS score calculation. I know the formula ( [ (No. of promoters - No. of detractors) / Total responses ] * 100), but whenever I enter into a beast mode calculation, it does not work. How do I need to format my survey information data, or write my formual to get the card to aggregate correctly and…
-
Alert History as Dataset
In each of the individual alert, we can view its Alert History as a line graph or as a chronological list of trigger event. (ref https://knowledge.domo.com/Optimize/Notifications_and_Alerts/04Managing_Your_Alerts) We create alerts to monitor our system health and want to build our KPI around how often a given alert is…
-
Weighted Average formula - beast mode
Hi all- I am using a beast mode to calculate the weighted average of days between two dates (payment due date and invoice date). Formula here: SUM((`PAYMNT_DUE_DT`-`INVOICE_DT`)*`RECPT_AMT_USD`)/ SUM(`RECPT_AMT_USD`) However, I realized there may be some zeros in the output that are possibly causing the weighted average to…
-
Adjustable % column
I'm working on an ask that I'm not sure is possible to meet. I have delivery data that I need to calculate the on time percentage over an adjustable timeframe. My key columns are supplier name (column1), PO lines delivered (column2), and PO lines delivered on-time (column3). I also need to display a column that show the…
-
Combining Different Rows into a Single Row
Hello! Was wondering if there is any Domo function/beast mode that can be utilized to combine results of a column across multiple rows to display in a single row. For example, if I had company name and office locations: Row 1: XYZ | Pittsburgh Row 2: XYZ | Fresno Row 3: XYZ | Dallas Could I have it so Domo shows 1 record…
-
How can I set default page filters for each of my dashboards?
Hello, I am trying to set default filters for each of my executive dashboards. The problem is that each dashboard has exclusive data that should not be visible to others. For this reason I wanted to set page level filters to make updating each dashboard easier. Is there a way of doing this so that the data will always be…
-
How to Make a Card of Total Ratio and Recent 1 Year Ratio
Hi There, I need DOMO Dojo expertise to help me on create 2 card using Beastmode calculation. I have a basic data to create this 2 card: Month date (201706, 201707, 20178 etc) Product name, 2 Type: Panel & MB Monthly defect qty Cumulative sales Idea: The Beastmode I should create is: Cumulative Monthly Defect Qty Total…
-
How to make a Monthly Total Sales & Price Per Unit and Summary Table With Corrected Color
Hi there, Since I'm a beginner user in DOMO, therefore I need helps to create 2 cards as below: 1st Card: Monthly Total Sales & Price Per Unit (Bar and Line Chart) Green Bar: Monthly Total Sales in Product Grape Line Chart: Unit Price of Product Grape 2nd Card Table card with exactly background and words color. Header of…
-
how to visualize
Hello I have time and date of equipement use and I want to visualize when they are running. For example something like a calendar; weekly based or graph bar with hours on Y value from 7 am to 7 pm and a bar showing if the equipment was used or not. Data are date/time of start and date/time of end usage for each equipment.…
-
gauge with custom tick marks with values showing
Its possible I am missing it, but I went through all the gauges and settings and did not see how to do this: 1) a gauge with visible numbers for the tick marks 2) Tick marks that are custom values (ideally supplied in the data set, but even manually entered in the settings would be fine) The idea would be to see the tick…
-
Can we set Dynamic color rules for Different inputs/conditions provided by user filter?
lets say, for year 2019 different threshold color rule can be set and for year 2020 different threshold color rule can be set ?
-
Can I arrange these quarters like Q1,Q2,Q3 and Q4?
I have created calculated field Qno and assigned values Q1, Q2,Q3 and Q4 accordingly but it is showing like this in card ? How can i arrange these ?
-
Swapping field names that is used in multiple columns.
Hello, I want to swap a field name that is in use in multiple cards and would like to change this field with a different one. our dataset isn't powered by magic ETL. Any other way to do this?
-
Multiple Countries Map
Hi, In using the Domo country map, I'm wondering if it's possible to assign the same value to a group of countries without repeating the row. For example: Country - Value Kenya, Uganda, Tanzania - 10 Italy - 18 India - 55 Thanks
-
Hi , Am getting the error while saving the card
This error " There was a problem saving your card, If the problem persists, contact Domo Support Team. Please assist on this.
-
Regards to transforming data prior to joining with another data set.
Attached are 2 different samples of data. Both are in similar format, and have plenty of same columns. The price list is where the bulk of what I am going to use will come from. It is the full inventory for a site. the total number of units, number of occupied, number of vacant etc... It is rolled up in to a single row for…
-
Show x-series minutes with no data.
Hi, I'd like to have a graph by minute and a heatmap for the last 60 minutes of a live data feed, at the moment because the X-series is data driven if data stops coming in the x series stops at the latest minute available in the data. I'd like the graph to always show the past 60 minutes even if data hasn't arrived, and…
-
Adding a New Column to Calculate Difference From Week to Week
Hello, I am trying to add an extra column that will calculate the difference in order volumes from week to week. See attached screenshot for details: Week 1 -> Week 2 difference is 7394 Week 2 -> Week 3 difference is 53 Week 3 -> Week 4 difference is 452 Basically using the current week's number and calculating the…
-
Can we change Legend name in cards for YOY views and normal views ?
Can we change Legend name in cards for YOY views and normal views ?
-
Integrate Mapbox to Domo
Hi All, Currently, learning Domo and trying to wrap my head around the platform. Can anyone give me some advice/guidance on to integrate the map from mapbox.com? I am trying to build a map of NSW state - Australia with postcode(zip code) and overlay with buildings' location. Similar to the map in this article: Flexible…
-
expected beast mode behavior?
In trying to debug a beast mode issue, I created a simple beast mode: sum(1) Now, when I put that on a single value card, it displays "179". This is the same behavior whether or not I use an aggregate function. Can anyone explain that behavior? Screengrabs attached:
-
odd beast mode behavior
Hi- as I was creating a beast mode, I saw that it works great in a single value card, but uses the wrong values in the summary number- same exact beast mode. Any idea on why this would be? See syntax below. The single value renders the (`Opp Value`)*.05 correctly, whereas the summary number disregards the beast mode calcs…
-
Beast Mode Not Allowing Card to Save - AVG SLA BEAST CALCULATION, HELP?
Hi, I previously created a table card where I was able to add the beast mode below but when I needed to make an edit I was unable to save as it gave the Unable to Save your card contact your Domo Support Team. Below is the table card I am trying to save: The beast mode for AVG SLA used. When I delete this beast mode I am…
-
Issue with Beast Mode Calculation not displaying on the card.
I am trying to find the conversion % for two different marketing sources. What % of those that inquire in either the walk in channel or the phone channel actually rented. I wrote this beast mode calculation, but nothing is displaying: SUM(CASE WHEN 'lead_source' = 'Walk_In' AND 'unit_rented_c' = 1 THEN 1 END)/SUM(CASE WHEN…
-
Flex Table Number Formatting
I have a flex table where I am showing the first values and last values as columns. Domo wants to abbreviate some of the larger numbers, but I don't want it to do that. I can't seem to find a chart property that lets me control that. See screenshot. Does anyone know if this can be controlled? Or is this a feature request?
-
How do I build a card?
Hello, I'm new to Domo. Wondering what best practices are for building cards?
-
Market Share (% of Total) and % Change/Trend Calculations
Is there a way using beast mode, or some other functionality, to create the following two equations in a DOMO card — to display on graphs as well as in a table/pivot table. 1) Market Share as a percent of total. In other platforms like PowerBI with DAX this would be achieved with something like the following random…
-
How do I build a card?
Hello, I'm new to Domo. Wondering what best practices are for building cards?