-
May Community Forum Highlights
Hello Domo Community! It's June! ☀️ Which means it's time to post the May Community Forums highlights. Follow the discussion, ideas, and user links to contribute to May's hot content 🔥 Leaderboard Top 3 We love seeing the monthly competition. @david_cunningham knocked @GrantSmith and @ColemenWilson out of the top spot for…
-
Multi value comparison
Hi, I am configuring a multi value comparison card. I have Sales column which is being configured in Gauge Value. In Comparison Value, I want to input the value of Sales Column itself but of previous year. I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I…
-
Drilldown tables on cards displaying info from multiple dates
I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…
-
GROUP_CONCAT function in Dataset View vs MySQL Dataflow
I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is…
-
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…
-
Is there a way I can log in as a user?
Many of the softwares I manage allow admins to log in as users to test them, troubleshoot, see what they see, etc. Is there an option in Domo to do this? Specifically, I have a page with multiple PDP'd datasets. When I select the policy at the top, it doesn't filter all the datasets, only the one that informs the first…
-
Identifying what data came from which connector on a card.
Hello all, and thank you for any help. I have my magic ETL flow built out so a report is pulling information from two different connectors. There does not seem to be a batch ID or file path as options for me to select, which I thought would be the method to identify which system they pull from. Does anyone know how to…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Problem with Workflow
This is my first work flow project and I ran in to some problem while I try to create an alert on cards, and when I try yo attach the action, it shows me an error message
-
Filtering Against "Potential" Field Values
I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time. Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values. Is there any simple way to establish these potential values…
-
Having both horizontal and verticle marker on a Line Chart
Hi guys, As in the title, is there any way to add two reference lines, one verticle and one horizontal in a DOMO line chart? The solution can be DDX or the default line chart. From that, is there any way to add the third horizontal… if there are ways… Thanks, Long
-
Improved filter interactions
As of right now the domo filter bar (screenshot below) allows you to natively filter a date through the menu to the right. Said filter,however, only affects cards within a dashboard and does not affect whatever dimension you are selecting from the bar itself. In the screenshot you can see a City dimension. That dimension…
-
how can i design this kind of chart in DOMO?
x axis is the month left Y axis is the stacked bars. each stacked bar is 100%. blue one is for normal order. orange one is for sampling order. they are both in %. they are the percentage each order type takes and are calculated based on the corresponding order quantity of each type. right Y axis is the lines. blue line is…
-
Display state selected
Hi, I have a map card which has the values populated for all states. I would like to display the selected state name in a text box. However, I noticed, when no state is selected, the text box displays the state name which is in the first row of the data which is misleading. It should either be blank or print some message.…
-
why doesn't my pivot table chart show % when I select show value as % of parent column?
Your help is really in need! pivot table chart For values 发货单数，when I select show value as % of parent column, DOMO doesn't show %, why?
-
Displaying 1 to many records in a table
I have created a custom app for my users to be able to add notes to Invoices that are in collections. The relationship is 1 Invoice to many notes. Initially, my plan was to display the Invoice details in a table card ( Customer, Invoice #, Contact, Invoice Date, Invoiced Amount, Total Due, etc.) and the note data would…
-
Using Sum Distinct in Domobrick query
Hi, How would you go about fixing this error? When I remove Sum(Distinct) it works but I just want to add up the distinct values. Am I writing this wrong? The column name is called TotalProgress.
-
Count transactions AND sum quantity on specific transactions by type
I have a card that counts the transactions type by month. Some of the transactions have a quantity so I need to sum the quantity instead of just counting that transaction one time. I'm not quite sure how to go about that. I need to be able to say if it is this type of transaction then sum the quantity otherwise count the…
-
Can you import multiple tabs in an excel document using the email connector?
I have a file/data set that is updated weekly by using an email connector. Is there a way the file can have multiple tabs at the bottom and have all tabs imported?
-
Sorting Items in a Checkbox Selector filter
I have a Checkbox Selector filter that has fiscal weeks for a client to choose from. It currently looks like this: How can I get the weeks to appear in order left-to-right instead of vertically?
-
SFTP server connection error
Has anyone else received this error that Domo is ready, but could not connect to a server? Our IT partners said there are no server issues from the third party system we're connecting to. This connection has been set and running for several months, but started displaying this error 3 days ago and not uploading new data.
-
Beastmode Timediff Errors
Hi all, using the following to calculate time differences between requested and actual drop off times: TIME_TO_SEC(TIMEDIFF(Actual Drop-off Time,Requested Drop-off Time)) / 60 Seems like the math isn't panning out (first column should be ~25 in the time difference column but instead is showing 1415.80). Haven't used the…
-
Add Card in Mobile Layout and Hide in desktop layout
Curranty we can add cards in desktop layout which we can hide in mobile layout as it cannot be viewed in small screen. Similarly If we can add some cards specific to mobile view which can be hided from desktop view.
-
Formatting for Quick Filter Values
I'd like to be able to apply different formatting to the values in a Quick Filter list, just like I can change them in the visualization. Example use case: my report users are in Europe, so they use date format MM/DD/YYYY. The dataset date values are in DD/MM/YYYY. I can easily update this in a visualization, but the Quick…
-
Disabling email notifications for users in a certain group?
Is this possible? What options do we have to restrict emails that get sent when sharing dashboards / cards or alternatively can we setup special rules to restrict which groups can share and be shared to?
-
How to edit the bottom chart to look like the top chart?
How do i edit the bottom chart to look like the above chart? I need to make it tall and show the x axis.
-
Why doesn't my Map in DOMO have colors?
Is it because I have the Province/fsa name in 省份，that is a Chinese version province list? How can I change them in a batch? Can DOMO recognize the Chinese words? How does DOMO recognize the Chinese words?
-
Help In Domo
I have three months attendance data including current month, and I want to check the last two months leave percentage of an employee. I got it by using the Pivot but here how can I highlight those employees who has taken more than 20% leaves in both the months.
-
SUBDate As Filter?
Hi, Can I use SubDate to filter a dataset within Magic ETL? We import our leadership team monthly. However, there are certain reports where I need the end of quarter leadership team instead of the most recent leadership team. Right now, I have the quarter end date hardcoded, but I would like to have a dynamic function.…
-
How can we enhance visual customization in Domo dashboards for better data presentation?
I am reaching out to get some clarifications regarding certain features that I have been unable to locate within the Domo platform: Cards: 1. Separate Background Options for Cards 2. Opacity and Transparency Adjustment for Card Backgrounds 3. Shadows and Borders Options for Cards 4. Shape Adjustment of Cards Dashboard: 1.…