-
Line plus grouped chart - getting Y axis and 1st series on left scale, 2nd series on right scale
Hi there, On the attached image, the Y axis value and the first series value are counts. Y axis = count of all orders (the blue line) First series column = count of delayed orders (the green bars) The second series column = (count of all orders - count of delayed orders)/count of all orders. Or, in other words, the percent…
-
Division in Beastmode
I am trying to find the percentage of data in 1 column. I have a field called Anonymous that is either a Yes or No. Would like to show the percentage of when the anonymous is yes on a line graph I know the equation is Yes/Yes and No but can't get it to work in beast mode Tried this count('anonymous' =…
-
Current Date to EOM Filter
Hi Team, I'm trying to filter some data but what I want it to do is to filter based on the date you're going into the report and end of the month. Example if I go in today it would show me the pending arrangements for 8/9 to 8/31 and tomorrow would be 8/10 to 8/31, etc. I'm thinking I have to do a beast mode for this, but…
-
Sort a Pivot table
Hello All, I am trying to create the beast mode for sorting the Pivot table, please see the explanation below. I have a pivot table where I am trying to have sorted at the Channel attribute level by sorting on the combination of Return_V + Reg. I have created a beast mode to do this but it is currently sorting at the lower…
-
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…