-
Tracking turnaround times Quartiles month on month
Hi, We need to report by month the turnaround time (resolved time - created time) for each Quartile. The top 25% quartile is time for top 25% of the requests when arranged in ascending order of their turnaround time. Similarly top 50% quartile is the median i.e. 50th percentage mark when requests are arranged in ascending…
-
Can you upload filters for values that don't exist yet?
My Domo data comes entirely from Brightspace datasets and we're in the early stages of user adoption of Brightspace. I'm running into the problem where I want to create filters, but Domo only lets me filter on existing data, I can't type in filter values pre-emptively. Example: I want to create a filter that shows how many…
-
Specifying Image Size and Margins
Is there a way to specify the size of an image in pixels when displaying it on an image card? I don't know of any way to do this other than using the bar below the image in the dashboard editor. Also, is there any way to control the large margins above and below the image in mobile mode? I imagine it could be controlled to…
-
ALL (as usual in PowerBI)
Hey Everyone! Our team is new in DOMO and we are having some issues with handling Beast Mode formulas as we did in PowerBI. DAX's ALL formula, for example. How do we manage in DOMO to use a denominator that ignores user-selected universe filters, like DAX's ALL does? We tried to use Window Functions, but it keeps…
-
QoQ Comparison By Week
I can't seem to get the right combination to make this line chart work. Series 1 = Q1 Series 2 = Q2 Series 3 = Q3 Series 4 = Q4 Line comparison by week (week 1-13ish) each plot is the count of activities that week Anyone point me in the right direction?
-
Separate metrics on Multi-line Card?
Am I crazy, or did we lose the ability to put a second metric in the "Series" section and have it display as a second line rather than the second metric being used as a true series? I'm trying to move an old card to a new dataset, and I've now lost the ability to have multiple metrics on a multi-line card? What am I…
-
Sum data based on several criteria
Hi All, I am new to Domo and trying to figure out how I can create a specific card looking at a few columns of my data. Overall, I am trying to search a particular day of the week (sunday in this case), then search for a certain criteria on that day, then add up the unique count. However, I am not sure if a beast mode…
-
Beast Mode Calculation for Yesterday
I am trying to get a % Change of Revenue between Yesterday and Same day last year. My beast mode formula was: (SUM(CASE WHEN `Date` = CURDATE() - 1 THEN (`Revenue`) END) - SUM(CASE WHEN `Date` = SUBDATE(CURDATE()-1, INTERVAL 52 WEEK) THEN (`Revenue`) END)) / SUM(CASE WHEN `Date` = SUBDATE(CURDATE()-1, INTERVAL 52 WEEK)…
-
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…
-
Compare Goals this year and last year in the same graph.
Hi, I'm trying to create a bar line graph where I could see our current monthly results and the goal from this year, and also be able to see the percentage of last year's goal in the same graphic. Do you know what kind of visualization I could use? Thanks
-
SLA/Response Time Beast Mode
Hi Team, I am currently working on response time for tickets, we eventually want to get to SLA but since the metric will be new for this team we need to understand the average time it takes to handle a ticket. I am currently using the below to get the average response time displayed as HH:mm:ss…
-
domo.onFiltersUpdate() does not exist in domo.js. domo.FilterContainer() gives error. Any solutions?
Thank you for your time viewing this post. I have 2 issues ongoing in one of my projects. The description of these issues are given below along with their errors. If anyone helps me in resolving them, ill be grateful. domo.onFiltersUpdate(console.log); This function is rendering me this error: code.js:60 Uncaught…
-
Wrong Average Calculation in Beast Mode
Hi, I am trying to calculate the the average of my column which contains numbers from 1-7 and some blanks. I thought the Beast Mode ignore the blank cell when doing the calculation. However, it seems like it still include the blank cell in the Denominator. Below is the example, where the average should be 5.73 but the…
-
Beast Mode - Count Case When with multiple criteria
HI, Trying to use the below to count when both criteria are met. If an agent has a record for a specific date count 1. (CASE WHEN (COUNT(DISTINCT `ReportDate`)) >= '1' and (COUNT(DISTINCT `Agents`)) >= '1' THEN '1' ELSE ? END) It is not allowing me to calculate this. Can someone please assist?
-
Why isn't there a red to green theme for heat maps?
I have a table that I'd like to apply a basic red to green color color theme to. We need to apply this to a column that measures monthly production for reps, sorted highest to lowest. Color rules wouldn't work because their production numbers would increase every day. When I check the heat map color themes all I see are…
-
Adding Last value Forecast to the secondary value
For a dual-axis chart with a primary value using the left Y-axis and a second using the right. I am wondering if I can use the Last Value Forecast function to both the primary value - which is the default - and the secondary? Thank you!
-
Beastmode suggestion for a filter
I have a report that provides details on individual units it has a column that lets you know if that unit is rental or unrentable. it uses binary to illustrate this: bRentable 0 = “Unrentable” or “Offline” 1 = Rentable How can I write something in the analyzer that I can use as a filter that will replace 0 with Unrentable…
-
Period over Period Comparison of Two Date Columns
I am using a Period over Period card that's fairly simple. Gauge Value - Count of Windows OS machines from the asset software (KACE specifically) Time Period - MAX LastSyncDatePatch (most recent sync date in that column) My card date Date Range is Month to Date and what I need to compare to is a column called…
-
How exactly does the rand() function work
Based on my testing it seems like the rand() function returns a guaranteed set of pseudo-random numbers seeded by the optional 'value' parameter. For example, if a create a card with a beastmode, the first time a beastmode, calls the rand() function (with no parameters) it will return a value of ~0.69. The second time the…
-
How to custom name data series in legend?
I'm looking to name each series its own custom label, take a look: So for example, I want to change the top label to "Point - Tree - Batch", the second label to "Point - Tree - Manual", the third to "Linear - Curb and gutter - Manual", and so on... a custom label for each of the eight series. Can anyone help? Thank you.
-
Customising Email Layout for Scheduled Report
Do you know if its possible to customise the email that is sent from Domo during a scheduled report. Currently, the format is not great and hoping to have the ability to customise it if possible.
-
Count if
Hello, I need a separate count of 4 specific values in 6 columns. I believe I can get one of the counts, but am not sure how to get all 4 values counted. Formula for one of the values: COUNT(CASE WHEN `Item Status 1-4` = 'Active' THEN COUNT('Item Status') END) After I get the values of each status, I need to get them into…
-
How Domo calculate the average of a column
Hi, In my data set, I have a column that has a score of 1-7. I want to use the average of this column. However, some of the rows in this column is blank. Is Domo just going to ignore these blank when calculate the average? Or I need to add anything in the blank rows to make the calculation accurate?
-
Range selector on mobile
Has anyone been able to use Range Selector on mobile. I have a card that works fine on the dashboard but when I try and do any kind of sliding, nothing happens on mobile. Please advise
-
beast mode processing limitations
Our Domo instance is limited with federated data, but I noticed I can create case statements in beast mode to create a new field with associations with case statements. For example, I can map customers to an account manager with a statement, e.g. (CASE WHEN `Customer` = 'Joe Harris' THEN 'Mark Smith'), and I can use that…
-
How to get an accurate aggregate average of a percentage on a line chart?
I have a line chart that shows a percentage across categories (opens/delivered graphed by email campaign). I would like to show which campaigns are above or below average with a line on the graph. Because of the different sizes of the email campaigns I cannot just average the ratios - instead I need to divide all the opens…
-
Using Beast Mode, how can I use the last value when a value equals zero?
I joined two datasets with MagicETL, one a view of daily website visits, the other a weekly snap shot of subscribers. I would like to create a Single Value gauge card that shows the visits per subscriber (2.15 in my example below) with the latest subscriber numbers in the summary line (3,988 in my example). I would prefer…
-
Quarter Filter On a dashboard
Hello, I need to add a filter that contains the list of quarters in the data. I can get the quarters to show in the card by using a beast mode QUARTER (Date Range), but am not able to get the quarter to show in the shared filters as a drop down list of values. The beast mode is shared to the data set. Quarters shown on the…
-
Anyone using Data Set Views?
Are you using Data Set Views and if so, how? I recently had this turned on for my Domo instance but I'm not exactly sure what I can do with it. Any use cases would be great to hear about/learn from! Thanks.
-
Legend click/toggle behaviour
This question has been asked already here: Is there any news about th possibility to add this feature? As said, to give the possibility to select if the legend should keep or hide the select item. Thank you, G