-
Compare MAX date with YOY: Month-to-Date (MTD) Comparison
Trying to create a sql statement in magic ETL to compare YOY: Month-to-Date (MTD) by MAX date. My current code from is: CASE WHEN (MONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = MONTH(CURDATE()) and YEAR(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = YEAR(CURDATE()) and DAYOFMONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE)…
-
Ability to turn off click-through from emailed reports
Can we add a configuration to turn off the ability to click through links in scheduled reports? We have created some email-only reports that don't look good on the dashboard and we would like to disable the click-through. Thanks!
-
Help in Pivot
Hello, Requesting help on how to resolve this and appreciate your assistance. My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the…
-
Beast mode: SUM BY ORG NAME the AMOUNT if the state is granted or closed
Hi: Can anyone help with Beast Mode code: For each organizations_name, I want to get the sum of requests_amount_recommended if requests_state is granted or closed. organizations_name requests_state requests_amount_recommended org A pending_review 10,000.00 org A closed 10,000.00 org A closed 75,000.00 org A closed…
-
Data Structure Issue
Short version: how do I check if a field is a valid date? Long version: Using the NetSuite connector, our data has a field called Period. The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts…
-
DomoXCanva Challenge Details
What: Get ready to unleash your creativity and technical prowess in the DomoXCanva Challenge! In this challenge, participants will create a visually stunning infographic in Canva that displays their most frequently viewed analytics from Domo. By leveraging a Domo App and integrating it with your Canva graphic, the metrics…
-
DomoStats - Workbench should include Schedule Groups and Job ID
Domostats - Workbench has almost all the information we would need for tracking purposes. Including Schedule Groups names and the Job ID would make it more effective.
-
Workbench Details Dataset
Is there a way to get a workbench dataset similar to the governance datasets available on DOMO? I understand workbench functions on a local server but there's got to be a way to export to excel or something workbench job details. Is this possible?
-
How to omit values from a field if it contains a letter inside it
I have a really quick simple question I am using the field "item Number" but I need to omit any Item Numbers that contain the characters "A, B, C, P" I tried using the filter tool on the analyzer and used the Match Values option set that to does not contain "A, B, C, P" but that doesn't seem to work Here is the screenshot…
-
Yesterday's Month - Date Range
There are many cases where the Date Range "This Month" fails to provide the current data during the first day of the month. Our reporting/data is normally up to "yesterday"; which means that during the first day of the month, the option "This Month" displays nulls due to the nature of the data. Having an option to display…
-
Certification Expiration Date
Under certification, there is an option to "Expire if Edited" any content. However, it would be great to have an option to include an expiration period to allow users to revise the version of the card/dataset and re-certify to ensure the best quality. For example, adding an expiration period in days. (i.e. Expire in ___…
-
Include Owner and Description fields in the Admin Group dataset
See title.
-
Compare a beast mode to an arbitrary date range
I've been asked to create a trend that shows the number of open projects (y-axis) for an arbitrary date range(x-axis). A sample of my data looks like this: Project_ID Date_Opened Date_Closed 1 1/1/2024 4/5/2024 2 1/18/2024 4/6/2024 3 2/2/2024 3/1/2024 4 2/9/2024 5 2/27/2024 6 3/14/2024 4/20/2024 7 4/3/2024 8 4/11/2024 9…
-
Select Default DOMO Font
Not a fan of the new font in DOMO. Make a setting to use different fonts in Admin so we can pick.
-
Embed dashboards available for student accounts?
Hello! I am trying to embed a DOMO dashboard in a website. I have a student account. Is this functionality available for student accounts? If so, how can I use it?
-
Set Alerts off Data Visualization Card (not from Summary Number)
Hello - does anyone know how I can set an alert (preferably multiple independent alerts) off a data visualization card, that isn't running off a summary number? Domo help articles say that there are certain chart types that allow this but I am unable to find which ones. I have a table card that shows display campaign…
-
Filter in magic ETL
Hi, I am trying to filter a dataset using magic ETL. The logic involves examining each id in the id column and then return the row with the highest rank. This will remove duplicate ids. I have attached images showing an example: before transformation and the desired output result (after). Can we achieve this using magic…
-
What is up with the default drilldown chart?
The default chart view when I drilldown a card is extremely hard to see. The chart is so short I can only see 3 to 4 lines at a time. Even if I zoom out a lot it only shows like 6 lines. I am using the latest Chrome if that helps. Can Domo please fix this? I know we can make a custom drillpath but we have many cards and we…
-
Set Default Email Notification Option to Disabled
Our organization uses Domo Everywhere platform embed into our clients' portal, being the only way for our clients to actually access their instances. Therefore there is no need for the client to receive any email notifications from their Domo instances for any activities such as page sharing, scheduled reports, alerts etc…
-
Admin > Activity Log -- Need EXCLUDE filter on Person list
Please give us more dynamic filters on this page! I would love to be able to exclude myself from the "Person" menu. I use this all day to make sure users are logging in, accessing content, etc. DomoStats is helpful but I love this real-time data, and I have to constantly scroll through my own activity. I would rather be…
-
Reports download
It will be helpful if an option is available to download multiple reports at once after selecting different practices, currently, the download options work after selecting multiple practices however the data is clubbed, and individual report download will help save time
-
Switching a Dataset to a Workbench
Hi, I have a dataset that I update manually and use in multiple ETLS. What would be the easiest way to get that going through Workbench without having to create a new dataset. Unless that's the only way. Thank you
-
Office Add-in - cannot control X/Y axis color when exporting cards to PPT
We are attempting to export a standard card from Domo to PPT using the Office Add-in with a transparent background and be able to control the colors of the X/Y axis labels same as everything else. Reason for transparency is a corporate PPT template that has a gradient that we're not able to match otherwise. Transparency…
-
Additional Currency Symbols
We are a global organization that operate in many countries. We have found a need to provide visualizations to our users in their local currency to avoid confusion and improve user experience. I'm happy to provide a list of the needed currencies but I would think Domo would benefit from adding most of the currencies around…
-
Break out rows depending on columns having a value
Hi, I have a dataset that looks like this: Name ID1 ID2 ID3 ID4 A 1 2 3 4 B 5 6 7 C 8 9 D 10 I want to break out these Names by the different IDs, like so: Name ID A 1 A 2 A 3 A 4 B 5 B 6 B 7 C 8 C 9 D 10 How would I approach this in Magic ETL? Thank you.
-
Beast mode for help Sorting column
I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this Engine 1 Engine 2 Plant Engine 1 Engine 3 Plant Engine 2 Engine 4 Engine 5 I figure if i can just do a formula to take out the number then i can sort them together based on…
-
Is it possible to send scheduled reports to anyone regardless if they have a seat in Domo or not?
Also, I need to send a scheduled report based on when the dataset is updated. NOT an alert which I know I can already do. It has to be a scheduled report in my case.
-
Handling "Replace vs. Append" Logic with Email Connector
Hello everyone, I'm seeking advice on configuring the Domo Email Connector for importing reports in a "month-to-date" format via email attachments. I want to a) retain the reports for previous months, but also b) replace the latest "month-to-date" report. Our goal is to achieve a combination of "Replace" and "Append" logic…
-
I want to show % of year...how do I do that?
The options I have are % of total and % of category, neither which work for this. How do I show % of year?
-
Failed to Convert Value from String Type to Boolean
Hi! I'm trying to setup a formula in my ETL where when the Registration Date is greater than 06/22/2021 we get the Order Item including the nulls. Before that date, I need the formula to include all order items but instead of nulls, I need it to say 'No Order Item'. So it would look like this originally. Registration Date…