-
Disable Card Options Button for non-owner/admin only
It would be great if the owner of a card could disable the card options button for the purposes of other users, but not for themselves. For example - I will often disable card options to keep the dashboard cleaner looking. It's frustrating to have to go in and re-enable for each card in able to edit.
-
Total row not calculating right
I have a card displays volumes for each of my customers. In some cases, there are duplicate volume numbers, but the total row only calculates one of them. For example, if customer A has a volume of 150 and customer B also has a volume of 150, the total row only calculates customer A. Any thoughts here?
-
Running Total Beast Mode
Hi DOMO Community, I am working on a project where I need to look at running totals. I have the following beast mode function written out and it seems to be working properly so far: Now, I want to try to fill any null cells. My original approach for this was to create a new beast mode called Incurred During Period where I…
-
Bulk Removal of Certifications
Seeking functionality to BULK remove all certifications in our Domo instance. Currently, certifications need to be removed ONE BY ONE. This is time consuming and tedious. Another downfall with the certification system and removing certification - if a certification has expired, the certification needs to be RE-CERTIFIED…
-
Modify formula
I need to modify a formula. CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END I have plants with event status. Each plant can have 1-4 tasks to complete a day. I need formula so if not all tasks are' complete' or 'completedlate' status (yes) then No. If all tasks are…
-
Magic ETL Checklist Enhancement Idea
Hello, It would be helpful if we had the option to add items to the Magic ETL Checklist. This would allow for each organization to be able to make sure everyone is designing their ETLs per their procedure/guidelines. For example, if we are requiring the designers to 'label' all tiles, then we could add a checklist item;…
-
Pivot Data in ETL
I have dataset i am trying to reformat using a pivot table. I cant use the pivot chart because it only shows measures as values so i am trying to reorganize my data using pivot in etl. My data includes Facility, Date, and Task Completed (yes/no). Beow on left is how my data currently is and on right is how I want to set it…
-
Domo Stats > App Studio views
I was able to see view of my App Studio content via the Activity Log dataset However, the item displayed is the page WITHIN the app that was viewed - and if the page name isn't really specific, it's not especially clear what app was therefore viewed. Please consider a parent/child relationship for activity tracking within…
-
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…