-
RANK Issues
Hi I'm trying to create a Rank, but sometimes it works others it doesn't don't know why, I have customers and I want to be able to filter by the top 5 customers based on Shipments I have tried multiple formulas and the validation works, sometimes the table works but the filter does not work: This are the formulas I have…
-
Need Column Header to show Day of week ie MONDAY, TUESDAY etc
I Need the Column STATUSDATE to show the day of week ie Monday, Tuesday Wed etc. instead of the DATE but can not figure out out to FORMAT.
-
How to automate DOMO report with Microsoft teams?
Hello, I want to automate DOMO report. I want DOMO to extract report and message the assignee name automatically over Microsoft Teams. How i can achieve this?
-
Chart Quick Filter to Change which Measure is pulled into Bar Chart
Is it possible to have a Quick Filter allowing user to select which type of measure is included as a value on a chart? For example I have Spend and Savings; if the user selects Spend the chart would pull in Spend and if Savings is selected the chart would pull in Savings only as the value.
-
Performance of private embedding
Hi, we are embedding using the flow described in this diagram but find it quite slow. 5-10 seconds to eventually render the board. Has anyone else found this or found a way to improve it?
-
Displaying a Blank chart
Hi, Is there a way to have a Chart display blank data until filtered. For example I have two charts one with products x,y,z and then the other being a blank chart. When I click on product X, I want the blank chart to display every customer. When no product is selected I want the chart to be blank. Hopefully that makes…
-
I am trying embed a dashboard and apply filters using the pfilter param and it is not working
Currently I am having issues getting the pfilter query param with the embed working in an iframe. I have followed many of the examples out there and have replaced every special character in the value with their ascii counter parts but nothing has seemed to work Here is an example of what I have been trying:…
-
Converting Dimension Column to Measures
one of the column in my dataset is $$$. However, it is in the Dimensions and will not calculate.
-
Dynamic comparison values
Hi Team, How to compare two dates values comparison in dynamics with examples coding Thanks, Raja Parthasarathy
-
Show portion total as % without showing other portions
I'd like to know how to take the percentage of a metric without showing other portions - for instance: I have footballs, basketballs, baseballs and lacross balls. If I sold 35 footballs, 25 basketballs, 20 baseballs and 20 lacrosse balls in Q1, in Q2 I sold x footballs, x basketballs etc. I want to see the percentage of…
-
Identify Null Roll-Ups in a Pivot Chart
Hi Folks, Question: How do I identify blank values in a pivot chart? I want to filter where all values are blank against any column in a pivot chart but no option. I can't do it in the ETL either because it needs to be dynamic based on a date selection. (dates are the columns) Context I have the fields 'People', 'Dates',…
-
Query code or Documentation for Domo Brick connection to Domo Magic Dataset
Can anyone share the piece of code you need or a document where I can find how to connect my domo data set to a domo brick? It's kinda frustrating as heck to see this documentation on how awesome the Domo bricks are, but nowhere does it tell you how to actually connect a dataset to it.
-
Flip Fields in Stacked Bar Chart
Not sure why I'm getting the below bar charts to show the 2 stacked values in a different order for each. Top graph shows Call + Slides (blue) on bottom of bar, Bottom graph shows Call + Slides (green) on the top of bar. I've not been able to find anything posted and have not seen any setting in the graph settings to…
-
How do I find the dataset alias?
Learning on the fly for DDX, and I can't even seem to understand how to find the dataset alias? Nor can I find documenation.
-
Creating Table Chart with Sales & Sales Last Year
I have a dataset where each dow represents a daily transaction 'date' for the 'productSKU', 'size', 'sales channe'l and also contains other columna where it sums the 'sales', 'stock on hand', 'units sold', etc I am trying to create a calculated field for 'sales last year' as a column for the 'sales' from a year ago for the…
-
Marking Duplicates So I Can Filter Them Out
Good afternoon, I am trying to mark rows that match up with each other as duplicates so that I can filter them out and only have the truly unique records left. Example So after I mark and filter the only record left will be the third one that doesn't have a match. What is the best way to do this? Thank you in advance
-
Storing Projected Values
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "Multi-Period Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was…
-
"Hide Insights for non-card owners"
Is there a way to 'Hide Insights for non-card owners' on all cards via workflow? If anyone know the API please share. Thanks, Kathy
-
Displaying DOMO Page Url in an iframe
Is it possible to render a page url within an iframe directly. For example, a DOMO page url: https://masschallenge.domo.com/page/212080366/ HTML: <iframe id="iframe" title="domo embed" src="https://yourcompany.domo.com/page/5675676/" />
-
Is it possible to load card data in google sheets using the DOMO Google Sheets extension?
Is it possible to load card data in google sheets using the DOMO Google Sheets extension?
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
Calculating a % based on multiple dates
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
-
Embedded DOMO dashboard not loading on click
Hi experts, I do have a system in which I am showing my 4 domo dashboards on one page via tabs. Each dashboard is embedded and does visible when we click on them and then I change the src attribute of iframe to load that embedded link. Now what's happening is that, when I first load the page using hard refresh, the first…
-
Domo Embed - reporting with a date range issue
I have an embedded dashboard that has programmatic filtering which includes a date range. This functions fine although i am now hitting a challenge in testing for the following reasons. I have records in the db table for when a product is available and another date for when its not available. I want a count of records that…
-
Burndown chart
I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a burndown I need a new column that gives total Duration per year of all courses due that year and then I want to be able to…
-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Question on Expanding Data to Display Unique Values
Is there a way to take the data that has a start/stop year (Column A/B) and have it expand while retaining the associated notes from Column C? The data is in Domo, but can manipulate in excel. The goal is to convert columns A-C to E-F. Not sure which platform makes most sense to make this happen (excel, access, Domo).
-
Add ability to ingest all files at specific folder location using the CSV SFTP Push Connector
The customer would like a CSV Connector using Domo SFTP that doesn't need the file name to match the dataset name for ingestion. But rather just ingest all files placed in a specific Domo SFTP folder no matter the file name. 1- Is the customer using the Domo SFTP or their own SFTP server? Domo SFTP 2- Do they need regex to…
-
How do I logout of a domo instance?
I have created a new organization in domo everywhere so I could share dashboards with a client. Normally there will be a profile picture at the top of the page where I can select log out, but this does not appear within this new instance. How do I logout so I can login as someone else?
-
Beast Mode is Inaccurate
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…