-
Preview Window Limits in Magic ETL
There is currently a 100 rows preview window limit when you do the preview run on the ETL. We need to increase this as it can help drastically with further work in the MagicETL.
-
Accounts with Profit Sharing Formula and Filter
Hello, We've got some customers that have profit sharing rules in place. As my data comes over it doesn't take this into account so it shows full profit attributed to us. I'd like to have a filter to toggle profit sharing on or off to show either full profit or the profit taking into account the sharing. If, for example, I…
-
Date Formatting in Tables/Charts
Hello, I am new to domo so hoping this is pretty basic to update. My date columns come in the following format "Jan 23, 2024" in my raw data. When I pick my date fields in any cards it only shows the year 2024. In some cases I will want columns or rows to be months or possibly days or weeks. How am I able to pull other…
-
Y Axis on Horizontal Bar - Allow Long Labels by Default
I was thrilled to discover the "Allow Long Labels" checkbox on the horizontal bar chart - however, I only think to go into Analyzer and apply it when I realize my labels are cut off in the first place. I would love to have Long Labels allowed by default, and we can uncheck to shorten to the ellipses version of labels Can…
-
Year Selector / Filtering for YoY Function (more than 5 years)
Hi folks! I have a range of cards where I am quite limited by only being able to show current year and back 4 years YoY. There are times when I need to show much older data or exclude years (like 2020 or 2021). Can we add the ability to select more years / filter the available years etc. Using this in conjunction with…
-
Custom colors based on PDP's
I would love to be able to show a bar chart (or a variety of other charts) that would allow me to call-out the specific user within the data. For example, if I have a bar for 100 doctors ranked high to low, it would be very useful for a specific doctor logging in to be able see everyone else as blue, and he/she as orange.…
-
Domopalooza Workflows Feature Release
We are excited to announce new Workflows enhancements. Workflows is a low-code logic-building tool that allows you to streamline data-driven processes and spend less time on complex business activities. With Workflows, you can automate routine tasks to increase operational efficiency; orchestrate steps and actions; and…
-
DataSet View -- Add to DomoStats
I would like a DomoStat report that included information on ownership and use of DataSet views. We have something like this for Datasets, Dataflows, Cards, Pages, …
-
Use Case for Recursive CTE -- Or is there an alternative?
I am pulling DomoStats data sets for: DataFlow Input DataSets DataFlow Output DataSets First Step - Combining input_output defined as: Select dfin."Dataflow ID" as dfid , dfin."Datasource Input ID" as dsin , dfout."Datasource Output ID" as dsout from "dataflow_input_datasets" as dfin join "dataflow_output_datasets" as…
-
Window Function KB article
Domo does not appear to have a KB article for window functions despite having one for (newer) Fixed Functions. It would be nice to have both. Additionally it would be ideal if the Functions list in Beast Mode editor included all the available functions including window functions or statistical functions (MEDIAN() ) once…
-
Appended datasets, output displays alternative blended datasets
I appended 5+ datasets, technically I should have all rows appended one another the other without overlapping. Some of my rows in the appended dataset looks overlapped with the rows from other datasets. what could be the possible reason for this?
-
Maintain Input DataSets when Pasting Copied Magic ETL Tiles
Currently, when copy and pasting Magic ETL tiles between flows, input tiles are scrubbed and become a plain input tile without a DataSet selected. I understand why you'd want to scrub this if pasted in the same flow, but it should be maintained when pasting in a different flow. This should be relatively easy to implement…
-
Dynamic Pivot
I love the functionality of dynamic unpivot for transforming my data vertically, I would love to see a similar functionality for adding columns
-
SSO between two apps
We have an app that uses the same SSO as our DOMO app. Is there a way to programmatically log into Domo at the same time as we log into our app without the user having to interact with any DOMO UI? We want to add a card to our app that uses PDP.
-
Update all attributes(department, title..etc) of User API
With the dynamic groups being able to pick the users automatically through user attributes, it is very convenient if we can automatically change the values of user attributes, example, department. set department through API→ pick that department and set to dynamic group, with such dep name,, I badly need this now actually..
-
Filter Rows Tile | Option to include or exclude NULL
Currently if you use a filter such as <> or != "xyz", this will also filter out any NULL values in the column as well. This is default behaviour for SQL, and I do understand that the reason it's filtering out NULL is because it cannot compare a value to a NULL. So it implicitly excludes NULLs, just as SQL would. The…
-
Allow lag/lead on multiple columns at once
I think it would be helpful to be able to lag/lead on multiple columns at once, as long as the partition and ordering are the same. We have multiple ETLs where we have to lag/lead many columns, and having to create a tile for each column doesn't feel very efficient. Thanks!
-
Magic ETL | Remove Duplicates Tile | Select all fields option
It would be good to have a "Select All Columns" option for the remove duplicates tile in magic
-
Select All Columns in Remove Duplicates ETL Tile
Instead of having to add each column individually, it would be great if there was a select all columns feature for the remove duplicates step in the ETL.
-
Maintain tile position when copy and pasting Magic ETL tiles
When working with large enough groupings of tiles, or groupings near the bottom of the canvas in Magic and copy/pasting, there is a tendency for tiles being pasted on the canvas to be squished into the bottom. This can be a pain to untangle and reposition the grouping. It would be helpful if by default or through maybe a…
-
Beast Mode Summary Number HTML for filled Gauge
Hi All, Reading other post, it appears you can format summary numbers via beast mode. I have done so and my beast output for my number is correct but it is stripping out my style tag when implementing. I can change the span to a div or other html element and I can see that reflected in the UI but it always removes my style…
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
Domopalooza Cloud Amplifier & Magic ETL Feature Release
We are excited to announce enhancements to Domo's Magic ETL and Cloud Amplifier tools. Magic ETL Magic ETL is Domo’s secret weapon for building data pipelines with ease. With a simple drag-and-drop interface, Magic ETL makes it easy to clean and combine data without knowing SQL. In this release, enhancements have been made…
-
Survey form ( form builder) not loading on safari browser for the members
A survey form built through form builder is embedded on the membership portal and is now not being loaded for the members on mobile and desktop browser. Is this something that needs to be fixed by DOMO?
-
Card Title and Description Text Formatting Options
Currently there are no options to format Cart Title and Description text. Potential use-cases for text formatting include: (1) to call attention to Smart Text values (2) to use title text as chart color legends (ex. see the "1. integrated text" example on this page:) Desired formatting options are to be able to use Bold,…
-
How to visualize survey responses - 4 statements, 5 possible answers
We collected survey responses from customers for multiple programs, where they submitted their disagreement/agreement rating for 4 statements. An example of how the data is collected is attached. I would like to have a drill down that shows the distribution of those answers for each statement for only one program (bonus if…
-
Multi-period projection not working with my dataset
I'm new to using multi-period projections within card properties. The good news: I was able to successfully utilize this multi-period projections feature with a nearly identical card, except I selected "fall" terms in my filters. However, when I "Saved As" to create a new chart and simply changed to "summer" terms in my…
-
AppDB API Bulk Document Request - Size and Rate Limits
What are the constraints around usage of the bulk document create/upsert/delete requests in the AppDB API? I've run into a handful of errors with these endpoints that appear to not occur when I shrink the request body or querystring length below some magical threshold. Knowing the size or rate limits for these API…
-
CLI connection method
I am new to Domo, so I am wondering how beneficial is the CLI method in use-case scenarios
-
Change Number format in dynamic concat statement
I have create a concat statement to dynamically highlight a certain metric. Essentially it changes as the time period and other categories change. The number is showing in the format in the above picture and I am hoping I could abbreviate in Billion or at least show the number in account format. I would really appreciate…