-
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.…
-
Email connector - header row error
Hi everyone! We have set up an email connector and added the rules as below: HEADER ROW - 16 STARTING DATA ROW - 17 Update method - replace This is because the rows above 16 contain report summary data which are not required in the dataset. However, whenever the automated report comes through from the connector, we are…
-
Can I design the kind of chart with 3 bars stacked and 2 lines
I want this kind of chart in DOMO. below is the excel chart. there are 3 bars stacked and 2 lines. need help! thank you so much!
-
Reset filters on action or event
Hi, Can we implement a Reset all filters(global & custom) whenever user selects OptionB from OptionA in the variable selector? Variable selector values: Option A, Option B. Global Filters: Geo, Region, Type, Mode. Thanks in advance :)
-
Python NLTK Vader Lexicon not available
Hello, when attempting to import and use the vader module, I'm getting an error from nltk package saying I need to download 'vader_lexicon' This feels super basic so I'm sure I'm just doing something wrong. Any thoughts on what else to try?
-
How can I keep my data's time zone consistent? 24 to 12 hour conversion issue.
A colleague of my is uploading data currently in 24 hour time into workbench. But, DOMO unnecessarily converts it from UTC to EST when he tries to change it to 12 hour time. Is there a way for us to stop it from adjusting time that's already in the right time zone? Thanks! 🙇
-
Federated Dataset returned a 502 error
Hello, I am trying to create a federated connection but got an error saying "…returned a 502". I am able to preview the table, but I am not able to see any data on the created dataset because of this error. Any help on this will be very much appreciated. Thank you.
-
Grouped and Stacked Bar Charts
Hello! I am currently trying to make a grouped bar chart that is also stacked. Essentially I am trying to merge these two charts together. I need to show each facility (i.e. MTC, RTC, UTC, and GVII) grouped by quarter along the x axis. But I then need them stacked to show how many issues were identified based on the type…
-
Resizing Cards in AppStudio
When I click on a card/element to resize it, the edit panel on the right-hand side of the screen opens and dynamically resizes all the content, making it difficult to tell if my resizing is working as expecting. Is there a way to avoid this?
-
Google Sheet Connector ignore empty sheet option
Hi We have scenario that DOMO dataset need to sync from Google sheet event the sheet is cleaned up. So right now Google Sheet Connect does not empty dataset in DOMO when the Google sheet has 0 records. Please have such option in Google sheet connector to allow empty dataset in DOMO if the sheet is empty.
-
Default Message
I want a card with a single line of text. Not a table. This is to act like a caption textbox. To indicate last run. The text is to indicate most recent date within the dataset. Assume there's a column called [date]. Here's the tricky part. This date must be based on the data itself. We have many offices. When filtered to…
-
Enter list of filters independent of values in data set
I'd like to be able to type in a list of filter values for a card, regardless of whether the values appear in the data set. Use case: records can be in one of several states. I want to include 3 of them in my Card. However, there aren't always records in each of the 3 states, so I can only set my card to include whichever…
-
How to remove min/max/avg from Bullet Chart
I have some old bullet charts where these 3 lines are removed, but when I try building a new card there is no option to remove them: Was this option removed from this chart type so now you're forced to show min/max/avg for bullet charts? That seems weird. I already compared all the settings from the old card to the new and…
-
Interactive Calendar Filter
I need help to create an interactive calendar filter. I have 4 filters: Fiscal year, Fiscal quarter, Fiscal month and wanted to add a calendar for the custom range which is interactive with other filters: The problem is that when I select the fiscals, the calendar is not changing base on the selection: Based on above…
-
How do I find the value?
Hi all, I have a 1.5 million row table that has been used many times over. For some reason, when I went to use it this morning, it was not wanting to work. I have a 'Bankruptcy Date' column that I feel pretty confident only has dates in it. I get this error code when I try to run this dataset through a dataflow. I cannot…
-
FIXED Function Documentation: FIXED Add Label?
In the kb article for FIXED functions, an example for FIXED ADD is shown where the City dimension is added in the calculation. This is straightforward, but what I can't figure out is: how on earth is the user displaying the name of the city on the chart? Obviously the function will return the value: MAX(SUM(`Total Sales`)…
-
Server Health Status
Typically what we are looking for is a status of the DOMO Instance with respective Services with the capacity and config details. Please check attached something in simillar model
-
Last week data
How do I sum a measure (activities) specifically for last week (Monday - Sunday) within ETL? I also would want to do for the week before. For context, my ultimate goal is to take an existing formula in ETL showing total potential activities for the week (which is constant) and then subtract the actual activities for the…
-
can we design this kind of chart in DOMO?
Like below in excel chart. Blue bar is a series of data in left Y axis, and it is named ' Piece quantity ' Pink bar is another series of data in Left Y axis, and it is named ' Order quantity ' Yellow line is the series in right Y axis, and it is named ' Piece quantity per Order ' X axis shows the month of order. Piece…
-
how can I have the number always shown on the bar or near the line?
I want the chart shows the number value on the bar / line for us to see the figure. currently I can only get the number when I move the mouse arrow to that position. how can I have the number always shown on the bar or near the line? Thanks,
-
Multi-Line Chart with a "Stacked" Y-Axis?
Hi, is there a way to create a multi-line chart with a "stacked" y-axis? I've been able to do this in Tableau, yet I can't find an easy way to accomplish this in Domo. I've attached a screenshot of how it looks in Tableau. Here you can see that each line has its "own" y-axis. Having all of these on the same y-axis makes…
-
Lost Business Beast Mode
Hello, I am trying to figure out if there is a way to identify clients that we no longer have business with. Scenario: Client A and B has had closed orders with us in 2018-2020 us. Client A has had multiple orders in 2021, 2022, and 2023. Client B has no more orders after 2020. Is there a way to output Client B's…