-
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
-
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