-
Data label on Variance graph
Hello, Is it possible to change data labels on a variance bar line? Can't seem to find any option to do so. Thanks!
-
Changing Background color of a cell based on other cell
I have this beastmode formula going right now: CASE WHEN SUM(`Real Time`) <= `Today Goal` THEN concat('<div style="background-color:red; color:white; margin:-20px; padding:20px">',SUM(`Real Time`),'</div>') ELSE concat('<div style="background-color:green; color:white; margin:-20px; padding:20px">',SUM(`Real…
-
Dynamic Text to work with Global Page Filters
Hi, I am trying to create a dashboard that has data from various datasets but each dataset has its own date column. I want the dynamic text to work with the Global Date filters - not finding anything within the knowledge base of this. I've found if I clicked on a specific graph with the month it would drill down the data…
-
Does anyone know how to build this card in the covid dashboard?
Does anyone know how to build this card?
-
measuring cross-purchase with purchase category in both row and column
I'm trying to create a table that shows cross-purchase with customers, so what customers who purchased in one value of a dimension also purchased in a different value of the same dimension. Kind of like those old distance charts that have different cities plotted against each other on x and y axis, with the count of…
-
Problem with showing top-n results in an horizontal bar chart with series
I have an horizontal bar chart. Let's say the Y axis is factories, while the X axis is number of incidents in each factory in some time period. I want to show only the 10 factories with the most incidents, sorted by number of incidents. When I'm not using any series, the simplest way of doing that is to sort on COUNT of…
-
% of Contribution
Hi, I try to show the % of contribution and need some help with the beast mode. Right now, I have a Pivot table. Store are grouped by Sales Leader and the timeline is "This Year, By Month". I want to show the % of contribution of the store, in the Sale leader group and see evolution over month. I have try this beast mode :…
-
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…