-
How to show series of dates not closely tied to your data point?
Is there a way to show a series of dates in sequential order (either daily, weekly, monthly, etc.) without the date being closely tied to a particular data point?
-
Column failed to convert from String to Floating Decimal
I have a column that show 2023 sales as "$3,432.12" kind of format which DOMO identified as Text. However, I think I need to get rid of the "$" at the front before using Alter Column Tile to change it into Floating Decimal. How can I do that?
-
Move output dataset from one ETL to another
I'm writing a new version of the ETL that generates our Employee Directory. The existing output dataset from the existing ETL feeds dozens of other ETLs, hundreds of cards, and quite a few external systems via either the SFTP connector or directly through API calls. When I've got my new version all set I'm going to have to…
-
Reading Contracts and answering questions with data and AI
I need a way to read my signed contracts and have the ability to ask questions using my data. Example: Sources: 10 pdf contracts loaded & my support ticket dataset & financial dataset Question: Average support tickets per contract with maintenance? What is the average cost per ticket. Note: these PDFs are not in an…
-
Name Error when using domojupyter.ai
--------------------------------------------------------------------------- NameError Traceback (most recent call last) Cell In[30], line 167, in getRaws(alchemer_ids) 163 question_answer_dict = dict(zip(trans_df['Code\nQuestion'], trans_df['Original_Answer'])) 166 prompt_str = 'translate the following dictionary…
-
Not max characters but what is the highest number allowed in a field
Hello, I know the text fields have a max of 1024 characters in a field but what about for a number and a fixed decimal? I have a value of ###,###,###,###,### that is just displaying blank in a fixed decimal field. Any input would be helpful.
-
How can I format my Alert so that it displays the information in vertical text?
Hi all, Currently my alert just has an attachment and link for the report. I have a customer who would like to be able to scroll and see all the order info. The first picture is what I'd like to have. The second photo is how it is currently configured. Thanks in advance!
-
Mega-Ultron-Super-Duper Connected Dataset to rule them all
BLUF: Should I join/append all of our data so we have one workable dataset? This isn't a technical question, but rather theoretical. We've got data in many places (I'm sure this is common): Budget in XYZ Financials in ABC Stats in DEF Stats Historical (just switch systems so have a different datamart) in LMN Everything…
-
Individual Default Filter View
It would be nice to allow individuals to set their own default filter views. Right now, the only way to set default filter views is to set it as a default for everyone. It would be nice to allow people to select their own, if there's a certain view that they always use, so they don't have to go through the dropdown every…
-
Issues with Bing Ads Connector
Hello All, Relatively new Domo user here, I just established a connection with Bing Ads to start pulling in all of our stats for our Bings Ads and straight out the gate I am seeing some significant inaccuracies with the data I am getting in Domo. Has anyone else had issues with Bing before? I know sometimes there can be…
-
Product Release 09.18.2024
Domo just got better! We've released updates on Data Collection, App Building, Connectors, Group Account ownership, Magic ETL, Workbench, and so much more. Read all about it in the Release Notes and New Features page.
-
Filter Request from Custom Domo App
Hi everyone, I am currently working on a custom Domo app using React, and I'm trying to develop an interactive filter app. I've researched the domo.js library and found that it mainly provides functionality for managing and operating datasets, users, groups, etc., in Domo. However, it doesn't seem to be suited for sending…
-
Shopify Inventory Level at Location
Hi everybody, I'm looking at a solution to retrieve the inventory levels of my products in Shopify. Any idea on how to do it without using an external connector? Thanks
-
AI Readiness Guide from Domo
Is your dataset AI-ready? We're here to help. Domo's AI Labs team put together a checklist so you can prime your data to be ready for any AI need or use case. Download and save THIS AI READINESS GUIDE. Then just follow the steps ✅ If you have any questions, post them in the comments below and I'll loop in our AI labs team…
-
Delete This Discussion
-
Beast Mode Description
Similar to how you can describe individual columns in a dataset (via the dataset schema view), a useful new feature could be the ability to describe beast modes. Currently, our practice has been to add a comment inside of the beast mode expression explaining what it's used for, but this comment cannot be referenced in…
-
View older ETL version without making that version the active version
I would like to be able to view older versions of ETLs without needing to make them active first. The way I envision it you would go to the Versions tab of an existing ETL and see a new menu item when you click on a version's ellipsis: View Version. Choosing this would open up that version of the ETL in read-only mode,…
-
Option to Remove "Duplicate Of..." Prefix When Duplicating Pages/Apps
Would it be possible to add an option to edit (or remove) the "Duplicate Of" prefix that gets added to every card after duplicating a page or app? If there was an option to specify the prefix (or simply keep the same name) that would prevent the need to rename every card after duplicating the page or app.
-
Be able to change the default color of positive and negative values in charts
Hi Community, We'd like to request the capability of changing/defining the default positive and negative color in "Change value options" in charts like "Multi-value". Currently, the default color for positive value is green and it's red for negative value. However, we'd like to avoid using red and green for potential user…
-
Add option to Trellis/Tiered Date Settings to continue cumulative totals
Currently when using Trellis/Tiered Dates on a card, a cumulative total will reset in the different sections. Whilst this is useful when reporting cumulative totals by periods, trellis/tiered dates need to be removed when cumulative totals are required across different periods. See below examples Suggesting to add an…
-
App Studio on Android Phones - Landscape View Distorts Page
I had originally posted an idea about Android phones not turning to Landscape view and being stuck in Portrait Mode in App Studio apps. That appears to be fixed now, however, when I turn my phone to Landscape View on the app I created, the view is quite distorted. I have attached a few screen shots below. In the first…
-
Dashboard Filter enhancement
My stakeholders prefer having filters at the top, but they have to scroll a lot to interact with them. Is it possible to create a fixed section, similar to how Excel allows you to freeze panes, so the filters remain visible while scrolling?
-
Find missing records from 2 tables
Excuse me for not providing a screenshot as the data is sensitive but I have 2 sales order details datasets: - A (sales orders for the year 2024 - 1.7M rows) - B (all the historical sales order for all years - 14M rows) - I want to see which orders are in A but not in B. It's pretty straight forward to do a LEFT JOIN, A =…
-
Appending a dataset said "Data updated successfully" but no rows was added?
I was appending rows on my existing dataset by going to Data → pick that Dataset → Settings tab → Details (drag my other dataset in), update mode: Append) → but in the History Tab I saw no rows was added: P/S: I was appending just fine yesterday, so not sure what happened
-
Decimals in Input Dataset not carrying over to Output Dataset
Hi all, I am working on creating a DataFlow as I needed to format a column from text to a date. During this process, it changed 'Net Change USD' from a Fixed Decimal to an Integer if I don't alter the column. I have altered the column to show 'Net Change USD' as a fixed decimal but it changed to just a decimal with the…
-
Change Bar Colors based on another Column instead of a fixed value
As a user, I want to see a bar chart where the color of a bar is dependent on another value within my dataset. Example: I want the color of the bar to be Red if the Y-Value is greater than the value of Column XXX. I want the color of the bar to be Green if the Y-Value is less than the value of Column XXX. Unfortunately,…
-
Symbol + Stacked Bar - States on X axis are not grouping together.
Hello, I have a chart where I want to be able to group together the different series by state but it keeps separating them out on the x axis. Not sure if it has to do with the separate beastmodes on the series. I have 4 separate beastmodes written where it looks for the average days in each scenario and have added all 4 of…
-
Pivot Table not Collapsing
The Pivot Table chart is not collapsing as before, when I have a couple of levels it would allow me to collapse the columns. Any idea of why?
-
Calendar Card Enhancement - More colours
Calendar to allow more than 5 colour customisations - at least 13 additional colours.
-
Previous day status from snapshot data
I have snapshot data everyday that has customers and their statuses. I want to create a formula that looks back one day and reports the status (previous day status) How would I do that in Magic ETL?