-
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…
-
Average of tickets by hour question
I have a card Daily Ticket Flow that has Count of tickets by hour for the previous week. My users want to see an Average of tickets received for that hour instead of actuals. I saw something in the old Community platform about Beast Mode using buckets and then averaging the bucket. Any thoughts? Thanks in advance! Michael
-
Help graphing a calculated field that sums up two data columns
I have a dataset that has daily data spanning back to the beginning of 2019. Let's call column A "Sales Date" Let's call column B "Daily Sales" Let's call column C "Employee Name" I then am creating a beast mode calculation for "Month" and "Year". I want to be able to plot in a bar graph the calculation, by month/year, the…
-
Single value card displays blank if specific date is selected in date range with existing data
Howdy, I'm still pretty new to Domo so bear with me. I created a single value card to display a sum of completed tasks for a specific shift and office (2 filters) for a productivity dash. The issue I am having is that the card displays blank if a specific date (feb 15) is selected within a date range under my 2nd shift…
-
DOMO Rank System
I have this card that I'm trying to rank by each month. It seems like it's ranking the numbers with both months, but I want them ranked individually by month.I.E. between 9 and 10 #9 is under Jan but #10 is under Feb. This is the beastmode so far. Rank() Over(order by COUNT(`Certificate#`) desc) Also is there a way to…
-
bulk updates to cards
Hello, I would like to remove a filter that applied to multiple cards. Instead of going to each card and removing the filter, is it possible to do bulk updates to all cards? P.s the filter is based on an actual field in the dataset and not a beast mode filter. Any responses will be greatly appreciated.
-
How to show top 10 contributors in any dimension field?
How to show top 10 contributors in any dimension field?
-
User access levels for drill path layers
Please let me know if it is possible to set up different user access levels for drill paths layers. Scenario: A card on shared page consists of a bar graph with company-wide term count by location, and a single drill path layer has been set up with a table to display the employee names along with other pertinent fields.…
-
Beast Mode: Table Card Total Row Issues
I have a beast mode I'm trying to use that calculates individual performance goals. Using a table card, and including total and subtotal rows. The first version of the beast mode was: (when sales dollars grow $2500 or more a 1% bonus is paid) case when (SUM(case when YEAR(`Date`)=2019 then `Sales Dollars` else 0…
-
2 Different Date Data Sets
I have a problem where I need to match up 2 different data sets to show funnel. Create Date & Demo Date. I need to show this data by week number. A demo date can be weeks after the create date. Here is my example: Data set 1 Week Create Count 1 10 2 20 Data Set 2 Week Demo Count 1 3 2 8 How can I merge these data sets do I…
-
Count Distinct - it's counting blanks
Hi - I'm using COUNT (DISTINCT to get a unique count of ID numbers and there are some records where the ID number is intentionally blank. I want these records to be excluded from the count entirely but this function seems to be counting 'blank' as its own unique value and is therefore adding 1 to the unique count which is…
-
Can we add notes in Domo Chart?
I want to add notes in chart . Can we do that?
-
General question on data from different datasets on the same card.
I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without…
-
Extra Spacing from Exporting to Excel
Hello, I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces. Is there any way to get rid of this?
-
Beast mode to count a variable with an if that reference other variable
Hi all, I am trying to create a trend line of the total number of customers we have that have reached an X revenue threshold by month. I wonder how to best do that whether from a beastmode or something else. The tricky part is that the data we have in domo is all written by revenue center in that one customer can have…
-
DOMO CLI Interface Search/Filter
I'm trying to better understand how to use the Domo CLI, and have a few questions. -Is there a way to search for all datasets/flow/cards whose name does not follow a defined convention? Ideally, I'd like to be able to utilize regex to search for patterns. Something like "list-dataset -n TEST%" -When executing a search, is…
-
Tableau-like Parameter actions
I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this: I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3). In tableau, I would set up a parameter (p_fruit)…
-
Filled Gauge Chart
I have a gauge filled chart built that has been working each month and is now showing an error. The field I am using for the time period is Date Closed and now it makes me pick a Max Or Min. That was never showing before. Is this a change? I am trying to show the Ave Days to Close incidents base on Previous Month compared…
-
Use card with drilldown as filter on a page
Hi! I have created a dashboard where I have a map that is drillable (it's a map that goes from a state view to a zip view) but since I have changed the interaction option the card is no longer interacting with the rest of the cards on the page. Would it be possible to keep both functionalities ( when a user clicks on a…
-
Lag Window Functions gave me split rows
I am trying to use window functions for lag/lead. However no matter how I try, the table still show splits. lag(sum(case when `control or target` = 'target' then `vol_usd` else 0 end)) over (partition by year(`trade_date`)*100 + month(`trade_date`)) Is there anything wrong here?
-
Imitating Calculated Line Value (Avg)
Domo allows automatic calculation of some values on bar charts (Min, Max, and Avg). These values can be shown as "Calculated Lines" on a chart for comparison purposes. The great thing about these values are that they adjust based on chart filters. I would like imitate the Avg value and display it in a Single Value chart.…
-
How to add a Jitter to a chart (a Scatter plot in my example)
Hi, I have a number of risks which are each ranked on a scale of 1 to 4 on 'Likelihood of occurring' and 'Impact of Occurrence'. When plotting the individual risks on a scatter plot, because of the relatively few scoring options, I have many points sitting on top of each other. I'm relatively new to Domo and wondering if…
-
Bar Chart - side-by-side comparison of category average and individual item?
Hello All, I'm interested in building the following type of graphic. Let's say I have a category such as 'Truck' and want to calculate the average cost for all categories 'Truck'. And let's say I would like to have a side-by-side comparison of that average compared to a particular 'Truck'. I'm having a tough time achieving…
-
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…