-
Pivoting Help
I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data. in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as…
-
Beastmode listagg/group concat
Hello, I usually refer to the list of magic etl functions documentation for functions that I can potentially use in beastmode since some working functions do not exist in the list within the beast mode editor. However, a function that can combine strings from multiple rows into a single string like GROUP_CONCAT and LISTAGG…
-
Alert dataset
I have created a workflow (with you help…thanks again) and it works great; however, the field that is changed currently does not show up in any of the stats/system datasets. The alert does not show up in the "Alert dataset" either. Just wanted to know if there is anything I need to do to have the cards that has been…
-
Goggle Sheets - Can a single cell be accessed and used?
I have a google sheet of goals that has a calculated cell that sums all in the column. Is there a way to access this number and use it? I have another dataset that gives me actual sales, and I want to use a filled gauge that shows actual to Goal. thanks, Brian
-
Card Color Options
Curious if anyone has a workaround for highlighting the top x rows of a table when creating a card. The color rule options are all based on the value of a column, but I just need to highlight the top 2 rows on the chart (as it is sorted on a measure column greatest to smallest) Essentially here is what it would look like…
-
Disable Card Detail View
On a dashboard, Under Change Card interactions, be able to have the card link to another page or item in Domo AND disable the card detail view. The card should not be fully disabled, just the card title, so when the users clicks on just the title of the card, it does not go into the expanded card detail view. And the card…
-
Sum of multiple filtered values
Hi, I am trying to create a % by taking a filtered value in Column A and dividing it by other, multiple filters in Column A. I am able to create the numerator, however, when creating the denominator, I can't get it to register more than one filter. I've tried 'AND' and 'OR' statements, but no avail. See below: SUM(CASE…
-
Has anyone tried Domo embed with Monday.com Boards?
Thanks to those who've shared "how to's" with Domo Everywhere and other major applications. I have a new question. Has anyone attempted to use Domo Everywhere (or embed) on Monday.com boards?
-
Effective Dating
I want to capture appointment differential data and report back using effective dating. So that if I want a snapshot of a specific date, I'm pulling the most recent changes up to that moment and ignoring the rest. I've done this plenty in SQL, but looking for a solution using Domo ETL. I don't want to re-invent the wheel.…
-
API using partition
I have a question. I am using APIs now and I would like to know if it is possible to do partitioning using APIs. I know using Magic ETL and using Workbench you can do it, but can you do it using APIs? If I can't is the next step doing recursion? The reason for asking is that I am uploading data daily and would like to add…
-
Ability to Remove Domo Everywhere List
We need the ability to remove Domo Everywhere list which is no longer active. At the moment, once you create a Domo Everywhere publication, it adds to the existing lists and there is no option to remove/delete them even if they are no longer in use or disabled.
-
A more flexible way to do Period over Period comparisons
Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in…
-
Using row headers on google sheets
The maximum number of columns when using row headers seems to be 100. Is there a workaround for this? I have to load multiple times with different datasets
-
Domo Everywhere - New Organization/Subscriber Site should not have SSO enabled by default
We are using Domo Everywhere to create new Organizations which, in turn, creates a new subscriber site for the organization. The subscriber site is created with Single-Sign On (SSO) enabled, but not configured, so the default login screen is not enabled. Our CSM gave us a workaround (that includes manually putting in a URL…
-
A Single Embed Link For A Domo Dashboard With Multiple Subpages
In many cases, a Domo dashboard is built with subpages, however Domo Everywhere only supports one embed link per page when I need to embed the dashboard in a non-Domo environment, so this means I have to create multiple embed links for the same dashboard with multiple subpages. I would like Domo to offer the feature to be…
-
How to connect Azure Cosmos DB with DOMO
I cannot find resource about how to connect Azure Cosmos DB with DOMO. Is there a connector right now?
-
Enhanced Card Locking Options
Revisiting some older suggestions, it's still excessively fiddly to lock cards If the lock option could be turned on by default this would be great, also giving us the lock option inside of analyser would make more sense than having to remember to go into the detail view after every card created to tick the box or do a…
-
Calculate a ratio
Hi, I am looking for a calculation that will allow me to look at a requisition number and then look at number of people Forwarded to Hiring manager and number who were hired and calculate a ratio For example the calculation should be able to say 3:1 for the below example 3 forward to HM : 1 hire Sometimes we have more…
-
How to count number of Occurrences in a Column
I have a dataset where I am trying to get a count of each occurrence a value in a specific column has: For the example above I would want the result to return that there are Two : "0's", Three: "Nulls", and Three: "1's".
-
Can a workflow be used to set off a dataset update and ETL run?
Can a workflow be used to set off a dataset update and ETL run? It's currently on a schedule for every 4 hours M - F but every Tuesday at 10:45 I need to run it one extra time.
-
Domo Buzz Dataset
Is there a dataset, or a way to get the data from buzz?
-
Ability to impersonate a user
We frequently have situations where a user can't see a page or they get "request access" on the cards. To help us diagnose the issues, we would like to be able to impersonate a user, to see what they see.
-
Domo - Dashboards and underlying pages and users data or dataset info
Hi, I'm trying to identify the total Dashboards and associated pages and cards with users info, I'm trying to identify if there is any stats dataset that shows dashboards and associated pages and cards info. I see there is Dashboards info under Admin→ Content → Dashboards where its showing parent dashboard, dashboard and…
-
Creating A Date Field
Hi Domo Community, How would I go about creating a usable date field from two columns I have? One column is the year, and the other is the month. How could I create a date field from those two columns? For example, 2/1/2024 from a column that has February and a column that has 2024. Thanks!
-
using Domo API and partition
Currently i want to append data using the API append method. However, i also want to update the last 2 days 2 a dataset on a cron job so that i do not miss a day. I know partitioning would only keep the unique record. Is it best to use recursion or partitioning for this?
-
How to Calculate a rolling 7 day Average and Rolling 4 week average? in a beastmode
Does anyone know the correct beastmode calculation for a rolling 7 day average and a rolling 4 week average of a value? Thanks, Garrett
-
Card/Control could not load
I have some Cards and Controls that are not loading. I need to figure out why they won't load and also set some type of alert/notification when they don't so I can fix them (hopefully before a user accesses them).
-
Table Subtotaling
Having an issue when trying to subtotal the time columns. I want to be able to see the total off all the times rather than the count of each row? etg. 00:00:20 + 00:11:57+ 00:05:07… I moved my beast mode into ETL formula to try and get the field to work, but I cant get anything besides 'text' field to work.
-
Errors with 'Duplicate Calculation Exist'
I'm currently getting the 'Duplicate Calculation Exists' error. when building and saving a beast mode to a dataset. However this dataset currently does not have any beast modes saved to it. In addition, there are no cards to this dataset that currently use a beast mode with this name. I understand that this error will pop…
-
Dashboard Filters - Way to only show the 'Choose Date' filter?
Hi all, Is there anyway to show only the "Choose Date" filter on a dashboard, while keeping all other page filters hidden? I am creating a dashboard with some DDX customizations, I have a custom set of filter dropdowns to streamline and speed up dashboard use within one of these bricks. I want to hide the non-date filters…