-
Allow the selection of filters that are not present in the data yet
I often have the need to to set up a card to show data that I will be expecting soon, but is not present in the data yet. For example, I will set up a card to show Outbound transactions with a rank of 6. This is in the data and produces a valid card. If I want to duplicate this for Inbound transactions, I cannot if there…
-
Dynamic Date within Beast Mode
I have a Beast Mode that is grouping transactions based on their date: CASE WHEN OrderHeaderLocalDate >= '02/27/2024' THEN 'Since Changes CY' WHEN OrderHeaderLocalDate >= '08/01/2023' AND OrderHeaderLocalDate <= '02/26/2024' THEN 'Prior YTD CY' WHEN OrderHeaderLocalDate >= '02/27/2023' AND OrderHeaderLocalDate <=…
-
Add a Column in a Dataset View
Hi, is it possible to add a column in a dataset view containing a text only? For example, I want to add a new column containing the word 'Board'. I tried Add Column then Create Calculated Column but the outcome is 1. There's no option for not aggregating it.
-
Dynamic PDP
What could be stopping data from showing after applying a dynamic PDP? I created a dashboard that has about 5 ETL Datasets. I then created a user lincesed group of 27 people and all theses users I created an attribute called GROUPING and assign the locations they can only access or see that locations' data. I then set a…
-
Create Conditional coloring based on a value not displayed in card
All details are summarized here:
-
WE NEED YOUR FEEDBACK: What topics would you like to see covered during our monthly meet-ups?
We're in the planning stages for this year's Community meet-ups and would like your input as we plan content and speakers. Help influence upcoming meet-up content by answering any of the following in the comments below: What AI topics are you most interested in? What Domo.AI features would you like to learn more about or…
-
GPT for Text/Sentiment Analysis
Previously we've used ChatGPT to analyze some free-form text responses to derive sentiment and underlying themes. Does anyone know of any add-ins or options within Domo that we could utilize to do the same thing? We want to combine this sentiment analysis with other insights that Domo shows us from our survey responses,…
-
Option to schedule datasets in UTC or local time
When we schedule datasets today, Domo schedules them in UTC, so there are no adjustments for Daylight Savings changes. This means that we need to reschedule datasets that must refresh at a specific time of day locally (i.e., 6 AM Central Time, regardless of whether we are in Standard or Daylight Savings time) twice a year…
-
Calculated field for before and after date
I have a calculation based on date that is only half working. CASE WHEN (DATE(Date)<'03/01/2024') THEN SS Revenue ELSE (SS Impressions*eCPM/1000) end In the formula, it is pulling in the correct amount when it is BEFORE 3/1/2024, but for some reason, it is returning 0 for anything after that date. When I look at the SS…
-
Where are the Magic ETL Formula Editor / Add Formula functions documented?
I'm looking for actual documentation of the DATE_FORMAT, DATE_TRUNC, and TIMESTAMP_TRUNC functions.
-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"
Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate a pacing percentage. (`Delivered Impressions` / (`Campaign Flight` - `Days Remaining`)) / (`Total Goal` / `Campaign Flight`) We've been using this dataflow and formula without any issue for months and now we're getting this…
-
Is there a way to use the LIKE operator to make it case insensitive, specifically in the ETL?
I have looked through the Community Forum trying to find a way to make LIKE case insensitive. I came across a way using ILIKE in the formula tile, but after trying it I found that it didnt work in the Formula. I am specifically looking for a way in the Filter tile.
-
Import Color Rules
It would be great if we had the ability to import color rules from another card. That would save a lot of time when we want to have similar color rules built on the same fields on different cards, but we don't want to save the color rules on the dataset. Here's a rough example of what the UI could look like.
-
Column level color rules based on multiple statements
I have a pivot table that it would be super helpful if I could color code columns based on multiple statements using the color rules. I know there is a work-around using HTML, but this would make it much simpler. For example, I want the cost per acquisition number to be green if below $20, and red if above. However, it's…
-
Custom Calendar Week On Dataset?
Hey! What if I want to establish a new calendar on a dataset? For instance, the third week of January would be CW1 and each week starts on a Saturday. thanks!
-
Selective filter settings on the dash
If the Domo dashboard filters can allow specific filters for selective cards on a dash level, that'll be a useful feature! I understand that we currently have the "Change Filter Exceptions" editing feature on a dash level to either filter the card on a dash level or not but I think we should have more than that. For…
-
Anchor Links for Dashboards
Looking for the same functionality on a web page or Google Docs' bookmarks.
-
Is it possible to color code map points based on a column in the dataset?
I'm using the Google Detailed Map Brick, and I'm curious to know if there is a way to color code certain map points using a column in the dataset that is powering the brick. For example, using the US Airports dataset, all the points are blue airplanes. I'm wondering if I could have some blue and some red, depending on the…
-
Domo should give an option to manage abbrevation of Billions, Millions,,K
The below logic should be default handled by domo for every no field. Case WHEN `Choose Metric` = '$ Sales' and LENGTH(Round(Sum(`sales_12w`)))>=9 THEN Concat (Round(Sum(`sales_12w`)/1000000000,2),'B') WHEN `Choose Metric` = '$ Sales' and LENGTH(Round(Sum(`sales_12w`)))>=6 THEN Concat…
-
Creating in app studio, posting in IOS/Google Play App store
Hi I read that its possible to post your app in IOS/Google Play store. How would you go about that? Thank you
-
Disable Views SQL Editor when it's been enabled
The SQL Editor in Views has proven to be invaluable when trying to fix other people's broken views. However, once the underlying SQL has been fixed I would like the ability to switch the view back to it's normal look and feel: most of my users don't know SQL and get freaked out when they see that big black box with the…
-
Drill down from chart view
Is there a way to drill down from a bar chart view without only clicking one of the x axis chart values? For ex: I have an inbound vs outbound bar chart - If I click inbound or outbound bar graph the drill path will take me to a view of each (inbound or outbound) by account - But i am trying to see BOTH Inbound/outbound by…
-
Some negative impacts of the new feature merged beastmode
Hi all, Recently there is a newly added Domo feature where the 'Merged from datasource..." beast modes will be created when cards that are using the beast modes are moved to a new DataSet. But we found that this new feature has an effect on the previous data source as well : domo will rename all the beastmodes merged…
-
Beast mode function to read attributes from end-user profiles.
It would be neat if I could create a beast mode that dynamically did something based on the current users trusted attributes. Something along the lines of: CASE WHEN ATTRIBUTE('Role') = 'Manager' THEN <X> ELSE <Y> END Or even be able to read the timezone from their profile so you can do real-time timezone…
-
Applying Filter Tile to Remove Nulls Not Working
Any ideas as to why this isn't happening?
-
HTML Table Styles
I don't generally work with html table chart type, but I have a dashboard that needs borders and subheadings if possible. I am only interested in what I can control in html tables, I don't want to use bricks. I can't find any web examples with fancy tables showing borders and headings such as the following. Can this be…
-
API Tokens - Tracking Usage / Governance
From a security standpoint it'd be great to see when / where an API Token is being used. Alternatively give the activity log have a flag that a token was used vs a user logged in the system. When someone leaves there's no easy way to track which APIs are used and what needs to be changed.
-
Adding Links to Card Descriptions (Rich Text Editor)
Currently, card descriptions only support basic text and smart text. It would be incredibly useful to be able to put rich text links inside of a card description. These could be links to other items in Domo or to external sites. I imagine this working very similar to how notebook cards currently handle adding rich text…
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Show "Output Rows" by Action in ETL run details
Currently when you view the run details of a MagicETL dataflow, we can see the rows processed, duration, and status of each action in the ETL canvas. It would be very helpful to see an additional column that shows the number of output rows of each step, similar to how we can see the output of each transform in MySQL…