-
Card Name vs Card Display Name
There are many times I need to display a specific name on a card and there are duplicates of that same card name however they are looking at different datasets. It'd be great to set an internal name vs a display name to display one thing but have a unique name to more easily differentiate between the different cards.
-
Variables to be able to reference a table
I would like to be able to reference a table in Variables. For example. I'm using variables to calculate and adjust revenue numbers from USD$ to CAD$ by doing a simple calculation of the current exchange rate. I'm referencing the rate now manually and have to adjust it manually in the variable What I would like is to be…
-
Grouping dates of service to match a pay period
I have two data sets one with employee pay information that is bi-weekly. And one that has information about the employee's work services they provided The one with employee work data has dates that show when the service was performed (Date of service) and how many hours it took to do the service (Billable hours). What I…
-
Need Some Inspiration On How to Represent This Data
Hi folks I need some inspiration on a chart type to represent the following data: User Feature A Feature B Feature C Feature D Feature E User 1 Yes Yes No No Yes User 2 No Yes No Yes Yes User 3 Yes No No Yes Yes User 4 Yes Yes No No Yes User 5 No No Yes No Yes User 6 No No Yes No No User 7 Yes No Yes Yes No User 8 Yes Yes…
-
User Tracking Analysis within DOMO Embed
We have deployed dashboards across our member portal using DOMO embed. We are hoping to be able to really track how much time users are spending on a dashboard, which dashboards are popular and unpopular, where are they clicking and how far are they scrolling, and when are they dropping off the dashboard. This is critical…
-
Why would I get an error "failed to parse text BATCH ID from column End Date New as type Date?
Every quarter I am adding a new budget file, and when I am adding Q3, I get this error. This did not happen for Q1 and Q2. The file I am adding does not have a BATCH ID column, but I do have an email connector set up to receive a weekly file for the actual data, that does have a BATCH ID. I know this one might be hard to…
-
Compressed (zip) Foler upload with 2000+ csv's, best way to upload and append all?
I am trying to upload around 2500 csv's of historical data into Domo to then compile into ~8 total files (they are deliniated in the file name of each output) and I can't seem to find an efficient solution to do this without uploading them individually. Any ideas? Thanks!
-
Embedded App Rules
Where can I learn about embedding apps with links? My main issue is when a user clicks on it they get an screen on this. I'm trying to understand better how to share content. Do I need to share the group/role or once it is embedded does that mean it is available internally or do I need to put that on Domo Everywhere for…
-
Order By
Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile. I'm currently working on a complex aging flow and running the flow makes the dataset wonky and…
-
Trying to do a lag function to calculate if a specific order is fulfilling back order or inventory
Hello, Please see below on what I am trying to do. I have open orders that are ranked based on earliest ship date and the ORDQTY. I am looking at the total sales QTY for that model and trying to do a lag calculation to see if a specific line item is fulfilling the outstanding sales qty or going into a negative number which…
-
How to show the series list in order (largest to smallest on a symbol line graph?
Hi all, Just a quick question on using a symbol line graph, is there any way to have the key shown in the same order as the data is presented on the chart? I.e. in the example below I'd like the triangle to be at the top of my list, then the square etc. Thanks in advance!
-
Graph export to PPT does not show legend
We have a visual composed of a Donut chart with a 3-line legend below. The legend consists of a color, a category, and a percentage. It looks great full size and and as a card. When I export it, though, the legend is replaced with the text "3 more…": Is there any way to keep that from happening? This is a very odd thing.…
-
Monthly Reports (Google Sheet). Help with next steps.
Hello! I have a question. Each month, I generate a report from Culture Amp listing employees who have completed anytime feedback. While the report contains essential information, it lacks various feedback labels (e.g., peer-to-peer, coach-to-coach). I manually add these labels in a column within the Google Sheet. My goal…
-
Ability to Copy and Duplicate Text Boxes on Dashboard
This is a simple ask… I would like to add the ability to copy and duplicate text boxes on a Dashboard Blue box is an example. Instead of having to start fresh every time. Should be a relatively easy ask.
-
Download all the cards in individual excel sheets in one click.
All the cards present in the Dashboard to be downloaded in respective excel sheet in one click. Eg. I have 190 cards in Dashboard, all the cards must be downloaded in 190 different excel sheets.
-
Values in between dashes
What is the best way to individually parse out a string like this? 1-2-3 want the following: 1 2 3 Open to use either Magic ETL or BM.
-
Filter persistence between pages within App Studio
Hi, I'm starting to play around with the App Studio. I was wondering if it would be a good way to have multiple dashboards within one place. Is it possible to persist filters across these pages within the app? For example, if I select a campaign ID in one dashboard, and then navigate to another dashboard within the app…
-
Open dataflow version comments for edit after the save
We have a difficult time getting people to document the changes they have made to a dataflow. I would like the ability to go back and document a certain version of a dataflow after it has been saved.
-
How do I get embed to update the dashboards with user input?
Long story short, built out an app with private embed (Using Swift since this is a MacOS/iOS application for work.), I can get the dashboards to display after logging in, yadayada, but they are not editable in any way, and I can't get any input pushed into the actual dashboards. I basically need it to do this: User logs in…
-
How to use filters to calculate MTD, QTD & YTD using 3 different cards?
We need 3 filters for Month, Quarter & Year and using the same we want to drive the cards to be show MTD, QTD & YTD calculations on same page. Please note MTD, QTD & YTD as 3 different Bar Graph charts. Is there any easy way to achievr this? Currently we are exploring Parameters/variables. Best Regards, Tejal
-
Beastmode | All seperate rows instead of one summed row
I've the following beastmode: case when DATEDIFF(Select Columns.Date,Date) >0 then sum(Select Columns.Totaalprijs)/COUNT(DISTINCT Email) else 0 end But instead of one row I get multiple rows. I tried adding 'sum' to other places in the beastmode but I'm receiving either an error or the same result. Can someone shed a light…
-
All cards using federated data sets and using filters are broken
I woke up this morning and all of my embedded dashboards were broken. After some analysis it looks like any card on a federated dataset that is also using a filter is not rendering. These are embedded cards using programmatic filters below and none of them are currently rendering. They were all rendering properly…
-
Adding a new dataset after creating a Custom App
Hi all, I created a custom app in Domo and originally when it was created, it only had one dataset in the manifest.json file "Cars." I wanted to add another dataset to the app and so I modified the manifest file to include "users" - Screenshot 1. I confirmed the new dataset is reflected in the brick - Screenshot 2. In my…
-
How to Setup UKG Connector?
Hello, We are trying to use the UKG connector, but it is not clear what all the fields are. Username: I assume this is a service account name? Password: I assume this is the service account password? Client Access Key: Not sure where to find this. User Access Key: Is this generated by the user account in UKG? Service Host…
-
ETL to Track Weekly Contracts
I'm trying to connect two datasets to track contract fills per week. The screenshot is from one of the two datasets and it includes the contracted amounts of each commodity and the Start/End dates of the contract. The second dataset has data pertaining to the amount of cases actually received per day (which I have…
-
Ability to see exported files/chart/images
Today, we cannot see which files are exported from Domo. We can only see the name of the file/chart/image but have no idea which cards they correspond to. This is a MAJOR security flaw that puts companies at risk
-
Export pivot table as shown on the card.
Currently exporting the pivot table to CSV/Excel does not generate a Pivot table but exports the rows of data. Users have to manually generate pivot table again with the exported data, which Domo should have done as a reporting tool.
-
How to join the Community Forums: Step by Step
Have you been a content consumer instead of creator on the Community Forums? Creating an account is really simple and allows you to engage by asking questions, starting discussions, and collaborating with other users. The Community greatly benefits from each contributing user. Follow this guide to sign up and get started…
-
Pivot/Group By - Make Multiple rows into one row and add columns
Hi Community - thanks as always for the consistent great help. I'm attempting to Group/Pivot/Join/Append (not sure exactly what the methodology will be) multiple rows of Patients into single rows with additional columns. Right now, each patient event is on it's own row. So, a patient seen on Monday and then also on Tuesday…
-
Help create ETL
Hello. I have 3 cards in my dashboard. Can anyone help me create an ETL for the 3rd column only, please? Here are the details and filters for each card: Card 1: Company Name not in 'MR' Destination contains 'MR', 'TC', 'L', 'NP', 'PP' show count of ID ——————Card 2: Company Name in `MR' show count of ID ——————Card 3 (here's…