-
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…
-
Labeling Year to Date as Fiscal Year to Date when fiscal calendar is used
I'd like to suggest a small labeling change. If I check off the "Use fiscal calendar" box, I'd like to see "Year to Date" become "Fiscal Year to Date", and same with the Quarter date grain. I generally leave a note in the description that the year in question is fiscal, but having it labeled in the date selector seems like…
-
Change Fonts
Would like to be able to set different fonts (i.e. Archivo, Roboto, Orbitron, etc.) to match our branding. Would be great if we could set a different default font.
-
Display Row count at every step in Magic ETL
Currently if you want to know your row count in Magic ETL at any stage other than the out put, you have to place a few temporary tiles to get there. I.E. add a rank and window tile to establish a Row Number column then aggregate with a group by to get the max row. Would really love if each tile could show the rows…
-
How do you restrict access to Admin Panel for normal users?
I noticed today that ANY user in Domo can access the admin panel - how do you restrict this? As far as I can tell there are no options for restricting this in either by roles or groups, and there's nothing available on admin/security options either. These end users are able to see the full list of other users setup in the…
-
Can the ServiceNow connector pull in multiple SN tables?
Hello. I'm working on getting ServiceNow data into Domo. There is a connector, of course, and I have gone far enough into the setup process to confirm that my credentials are working. I see the options to fetch standard and custom tables, but apparently can only mirror one table. Am I understanding correctly? Is it only…
-
How can I auto send an entire dataset each week?
Hi all, I am looking to send not just a dashboard or an analyzer view of a dataset but an excel export of that dataset each week. Is there a way to schedule this or do I have to download it and send it manually? Thanks!
-
Has Anyone Set Up Domo Alerts to Identify Long Running Dataflows?
We had an issue this last week where some jobs were duplicating and exploding rows. Some dataflows ran for 18+ hours without erroring. I'd like to set up some alerts for this and wondering if anyone has already done something like this and could share their set up. Thank you
-
DOMO Mobile APP refresh(lose filters) when another app is briefly open
We are using DOMO mobile app in iPhone and iPad. Our dashboards keep loosing the filters when briefly change to another app or minimize the screen. This behavior decreases heavily the usability because we have to filter the dashboards many times. I tried to troubleshoot the problem without success. It happens across…
-
Disable Scheduled Reports when data is blank
Is it possible to automatically disable a scheduled report when there is no available data on the last update/filtered date?
-
Email Connector: Unable to figure out why my regex not working
Dear DOMO community, I am at a loss and don't understand why in my email connector the regex .*PANAY.* will work when email subject is Fw: MSPANAY GROUP |IBITEM AND AVAIL - 9/8/2023 7:17:56 am but it fails when the email subject is Fw: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM When checking…
-
Dynamic Quadrant Lines in ScatterPlot
We need dynamic/smart quadrant lines in scatterplot. This feature is available in excel
-
how to design the function like excel slicer?
I found on others' page, there are function like excel slicer. what function it is? and how to design? hope for the guidance. thanks,
-
Where is the subtotal chart option? thanks
Help: pls see below picture which shows 'enable the subtotal chart option to edit these settings'. I didn't find the subtotal chart option. where is the subtotal chart option? thanks
-
Errors caused by Timezone, Where can I adjust it?
I found the dataset in DOMO is different from the raw data in google sheet for DATETIME field probably due to time zone different. Where can I adjust it? thank you so much.
-
Beast mode for the substring_index
I'm trying to extract the substring from an URL. URL: www.ab.com/level1/level2 I'm looking taking the level2 out of URL. What is the beast mode formula I can use here? I want to get: level2
-
What Date Filter to be chosen to get the data for Saturday on a Monday if Sunday is a Holiday ?
My Plant operates for 6 days from Monday to Saturday. Sunday is a Holiday. I want to schedule a report for Monday that can fetch me the data for Saturday. My scheduled report is working fine from Tuesday till Saturday fetching the previous day's data correctly but it is not fetching the correct data on Monday. I have tried…