-
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…
-
Magic ETL - Ignoring multiple Daily average amounts that display on the same dates
Hi, I have a question concerning how to fix an issue I am having when attempting to sum daily averages. Here is the issue that I have. As you can see in the image below. I have dates, IDs, and a daily average amount, set up in a dataset in my etl. In this sample, there are a total of 2 distinct IDs, the way I would like…
-
Table Cards Are Cut-Off When Exported To PowerPoint
Hello Domo Product Team, I have gathered from several different users that Table Cards are being caught up (missing bottom rows) when exported to a PowerPoint using the Microsoft Plug-In, and there doesn't appear to be a way to format or resize appropriately. Can you please consider an enhancement that will allow Card…
-
Issue where sharing an app is not giving them access to the reports
Occasionally when sharing an app studio built app with our users they will have all reports give the error "please request access" even though the included datasets are either A) not PDPed or B) already shared with the user through other reports. Has anyone else run into this or have fixes? It is happening to ~1/3 of users…
-
how to create a team in domo?
i was given this email, does anyone know what this means? im assuming its an admin task but i'm not sure. if you can provide me steps that would be nice. thanks
-
Need to extract all queries used in our SQL Server connectors.
We recently realized that someone in the past hard-coded database names — names which have since changed — in some of the SQL queries used in the SQL Server connectors. Unfortunately, we have hundreds of connectors, and opening up each of them manually to look for a problem will not be fun. To avoid doing that I want a way…
-
Calculate Sale Frequency
Attached below Sample data. The database table has location and sale date fields. I need to calculate Sale frequency report, which mentions if a particular location has a Weekly sale, bi-weekly or monthly sale wrt to the Sale date. Appreciate your help on how to calculate this in Domo? Thank you
-
2 datasets and filtering
I am trying to dive into using App Studio and I want to filter but I also want my cards and BANS to be affected by filtering. The challenge I have is that I will have at least 2 different datasets for the source. Is it possible for different cards to change when filtering when you have more than 1 dataset?
-
How can I set up to make the legend of a card always show up instead of getting greyed out?
Hi there, When hovering over either bar on the left chart, the legend on the right chart will sometimes get greyed out, but how to set up to make it not change the color at all?
-
Is there a way to conditionally show a column in a pivot table chart
I would like to only show a column for pivot table column based on specific criteria. For example we are showing training courses but I only want to show the number of employees for training 1 and not training 2. I'm using a pivot table chart. Attached is an example
-
How to add Date Control for Apps?
You know how every dashboard comes with an automatic Date control in the top-right corner? I'm looking for a way to add that to an App where I have a few cards all using the same Date field. I need the exact same functionality where you can select a range, select how the date is broken down (by Week, by Month, etc). Thank…
-
Settings not showing up in Analyzer
Usually there are a list of settings shown in the empty space I highlighted in the picture above. Is this some kind of glitch? I can't figure out how to make adjustments there.
-
DomoStats_Dataset Schema - Centralizing Feedback
I am working on feedback on each of the DomoStats datasets. Please add any additional feedback to the comments. Missing Fields: Column Description Column Tag Column Order Note - There is a field called 'Details'. The only value it contains is, 'This DataSet has not been indexed.' This appears to be for datasets with no…
-
DomoStats_Datasets - Centralizing Feedback
I am working on feedback on each of the DomoStats datasets. Please add any additional feedback to the comments. Dataset Types: Some datasets in the DomoStats dataset have null Import_Type, Data_Provider, and Source_Type, while Display Processing Type in the Governance dataset has dataset types for these datasets. Of note -…
-
ETL - How to spread a Budget over two dates within a variable date range.
I have various start and end dates for campaigns. I know how to calculate the # of days between any get set of dates. But, what I am trying to set up in the etl is this - if I have a budget amount, start date and end date, what is the easiest way for me to have the etl calculate the division of the budget over the given…
-
Control Chart Type via Beast Mode
With the recent enhancement around beast modes that allows a beast mode within a beast mode it has become easier than ever to utilize variables to control x-axis, y-axis, sorting, filtering, etc. through beast modes. With that limitation out of the way I believe the next logical enhancement would be to add a Chart Type…
-
DomoStats_Groups - Centralizing Feedback
I am working on feedback on each of the DomoStats datasets. Please add any additional feedback to the comments. For group reporting, the following 3 datasets would be expected: Groups - Unique list of ALL groups with relevant metadata like group type, creation date, created by, last modified, and number of members. Group…
-
SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!
Hi all About to through my Mac through the window if I can't sort this. How do I write a Beast Mode that sums data whilst ignoring ALL filters? Many thanks
-
Data Watchdog - Adding example queries
Hi team, I hope you're doing well! We've received feedback that providing example queries would be helpful in Domo features that accept custom queries. In this case, the client entered a custom query into Data Watchdog, but was returning an error. The issue ended up being a syntax error, but confusion could possibly have…