-
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
-
Sorting-Histogram Text
I have created a histogram chart with custom bins. The value is "text" and the sorting is off see below. How can I fix this?
-
Custom graphics for gauge charts?
Is there any way to customize gauge charts with a custom background, OR, better yet, with svg custom graphics for certain elements of the gauge (Like we can do with map charts)? I'd settle for a way to overlay a gauge on a custom background but right now it seems I can only customize a background to a color, not an…
-
BeastMode: Identify Odd or Even Year
This is something I solved on my own, wanting to share here in case someone else can use this approach. Also would love to hear if you have another way to provide the same solution. What was the business problem? I have a card that displays a KPI as a % over time. I wanted to color code the years so they alternate between…
-
Odd sorting issue when filtering
I have a card that displays the average leads per day of the week. To sort the days of the week in a chronological order I used dayofweek(`date_entered`) beast mode calculation to get the days of the week detail. Unfiltered everything looks good gives the average for each day of the week, Sunday - Monday. Once you filter,…
-
Sorting on both Columns and Rows when using pivot tables
Hello, I'm encountering an issue when trying to sort on both columns and rows in a pivot table. I want my columns to be sorted in date order, left to right - oldest to newest. I want my rows to be sorted in alphabetical order, top to bottom - A to Z. It seems to only apply the first sort in the list and ignore the other.…
-
How to add _BATCH_LAST_RUN_ to the dataflow built with SQL
Hello, I am trying to find a way to add BATCH_LAST_RUN column to one of the datasets I have created. I found A way - s to change replace method to append. In this particular dataset, I am grabbing the last 7 days' worth of data, so I need to replace the whole dataset on each run. Is there any way to add this column with…
-
Dataset beast mode calculations
Is it possible to copy over beast mode calculations from one dataset to another? I have one dataset which is using most of the same fields from other dataset. I wanted to copy all beast mode calculations.
-
Using Beast Mode to filter on multiple values?
Since using Domo, I've come across multiple scenarios where I need to filter fields based on multiple columns, and I haven't found an easy way to do this in card building. So far, I've resorted to hard filtering everything out using the ETL, but that isn't very flexible. Here's an example of what I'm trying to filter:…
-
Removing number abbreviation in line chart?
Hi All, I have a line chart where I'd like to display the Y-scale and amounts in the thousands, without the K or M abbreviation. Is this possible? For instance, $50,000,000 would display as $50,000K, and I can't find any way to remove that 'K'. Is a beast mode my only option here? Thank you!
-
How do i compare
I have a data set that is for fire drills we have a set scheduled shift i want to see when it is ran on a different shift so above the scheduled shift is the set shift the "Shift" is the one it was actually ran on. I am guessing it will be an IF and then else statement but not sure exactly how
-
Drilling between custom charts
Hello, I'm trying to make a tool using custom charts for our building, but I'm not sure about the feasibility of my design idea. Essentially, I'm trying to recreate the drill down process to Zip Code shown in this DOMO video: https://www.youtube.com/watch?v=UUZ_RvKX8O8&ab_channel=Domo, but instead using custom maps of our…
-
Convert Week Numbers to Start of the Week Date
I am trying to create a table graphed by week, and the analyzer converts the date columns to week numbers. Is there a way to convert these week numbers to start of the week date? eg. 5/23/21, 5/16/21, 5/9/21... 4/4/21
-
Dynamic Goals by employee title
I'm trying to set up a card to show employee performance against a corporate goal that is variable based on the employee title. Certain employees need to submit a report, and the # of reports they have to submit is either a certain number per day, per week, or per site visit, depending on their title. I have one dataset…
-
Excluding null values when using rank function in beast mode
I used "rank() over (order by asc)" in the beast mode, but I am getting blank rows on the top, followed by the correct rank . Is there a way to exclude the null values when using the rank function?
-
Percent of total by month in Pivot table
Hi, I have a pivot table card that shows the units and $ for products sold each month. How do I show the percent of the total $ that product is for that month or the total column? (see highlighted below). Rows: Region, Product Columns: SoldDate Values: SUM of Units, SUM of Price Thanks, Angela
-
Problems with Window Ranking Function
Dear friends, I am working in a CFD chart , to measure scrum metrics through the year for different squads. For one specific Squad, the chart is changing the date order when presents on Area chart, as you can see on the image below. Analising the scenario, it´s possible to identified that for this squad i had only…
-
Can PDP be changed at the card level?
Good evening, I have PDP in place for a data set in Domo but am wondering if there's a way to open up the policy for specific cards. For example, I have a sales data set where, the way the PDP is set up, salespeople can only see their sales info when they log in. If they want to see where they rank against other…
-
Card setup
Hi, I am not sure if this is possible. In my attached image, the bars in the Y axis are a beastmode calculation for a percentage Below, in the highlighted section, a user is wondering if, instead of the %, it could instead show the denominator of the percentage It does not seem so as the "data table" section in chart…
-
Distinct patients that need to schedule a follow up appointment
Hello , I am trying to figure out which patients did not schedule a follow up appointment after their last visit. I want to show last Kept visit per patient and if the patient needs to book an appointment . The problem i am having now is that one patient can have several Kept visits. . I want to show their last 'K' (kept)…
-
Alerts not sharing in Buzz channel for specific datasets
I have alerts set up and shared with a Buzz channel on several cards but the alerts only post to the channel for specific datasets. I still receive the notifications regularly otherwise. Does anyone know why this is happening? The data and card permissions are all the same.
-
How do I show a delta value for specific bars in a stacked bar chart?
I need a waterfall chart that supports stacked bars. Since DOMO's waterfall chart currently doesn't support stacked waterfalls I'm creating a waterfall effect using a stacked bar chart. For example: This requires me to duplicate the data from the first bar to the second bar and then visually hide it. However, I don't want…
-
Formula not summarizing in analyzer
Hello Dojo, I have a calculated field I am trying to apply to a time series chart that does not seem to want to summarize. The formula changes based on one of the variables - objective. case when `Objective` = 'CLICKS' then (case when (sum(`Clicks`) / sum(`Impressions`)) < .0082 then 0 when (sum(`Clicks`) /…