-
Do new values get swept into an "all" card filter?
I can't find that this has been answered before. If I add a filter to a card and select "all," what happens if a new value is added to that field? For example, say my field is "color" and I initally only have red, orange, and yellow. I set the filter to select "all." Later on a row that has color = blue is added to my data…
-
Looking for steps to creating a historical dataset and setting up partitioning
About a year ago I set up partitioning. Since that time the platform we were importing data has sunsetted. I am now building a new dataset for Adobe Analytics. Adobe doesn't seem to like long timeframes for imports so I've imported all of the data dating back to the beginning of the year by importing month by month and…
-
Adding checkboxes to a table
I am wanting to add checkboxes to each line in a table so that I can select the check box to signify that line has been completed as I am working through the list, is this possible? Next part to the question would be is there a way to make sure the boxes that get checked stay checked after I go back to the home dashboard…
-
July Community Highlights 🌟
Hello Domo Community! It's time to recap the Community Forums most engaged posts and users in July. Follow the discussion, ideas, and user links to contribute to June's hot content 🔥 Leaderboard Top 3 We love seeing the monthly competition. Huge thank you to @ArborRose, @GrantSmith, @ColemenWilson! @ArborRose 772 points…
-
Filter Options
Is there a way to make a filter like this on a dashboard? I can do it in the quick filters of a card and then the user is able to choose in betwee, greater than, equal to, etc. Trying to figure out if I can do the same thing but on the dashbaord level.
-
Can my output include projects that don't have a column value for a Split / Group
Hi all, I have this ETL which takes a multi selection attribute (Div) with 19 values and does the following: Splits each selection option into its own column Converts the columns to rows Filters to remove instances where there was no delimiter, because if only 1 of the 19 values was selected - these showed up as "Not…
-
Sharing custom themes in App Studio
Hey all! I want to share a custom theme I've built with our company's branding for all to use in App Studio, but I don't see the option to do that. Am I missing something or is this feature not available?
-
Trying to convert list of Objects to List of numbers
I'm trying to set up a workflow that would automatically add ownership to an Admin group when a new page is created. I figured I'd first identify any pages without the Admin group as an owner. To do this, I used the queryWithSql package to extract from the Pages Governance dataset all PageIds without the admin group as an…
-
Help with Gantt Chart timeline displayed
I'd like this Gantt chart to show the full range of dates of projects that I feel like I've already defined via the Start date and End date. I don't seem to understand the options in Date range, nor why I even need them. If my earliest Project Start Date is Jan 1st 2021 and my latest Project End Date is Dec 31st 2027, can…
-
Issue with Month to Date (MTD) Calculation on the Last Day of the Month
Hey Community, I have a head-scratcher. We are experiencing an issue with our Month to Date (MTD) calculation in our Daily Snapshot reports. Throughout the month, the MTD calculation works as expected, showing the cumulative revenue for the current month. However, on the last day of the month, the calculation does not roll…
-
Change ETL Trigger Dataset is Manually Updated
Hi Domo, It would be very helpful if we could have ETLs trigger differently based on if the component datasets were updated manually or automatically. Example: If a dataset is automatically updated, then the subsequent ETL triggers should work just fine. However, if one dataset needs to be manually updated, it will not…
-
Pivoting into multiple columns
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
-
How to do a distinct count of a certain number of digits?
I have a column labelled "Key". I am wanting to do a group count of these as otherwise I have too many rows (in table format). The first four numbers represent a project, I am currently doing a COUNT of these, and it comes back as 1 for each as the number is unique due to the numbers after the -. Is there a way to do a…
-
Filtered Period Comparison reflect in tables
Hi I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create another dimension with %chg based on two periods. For ex. User wants to see total GMV between Sept 1st to Sept 5th for 2024…
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
SAML SSO Certificate Revocation Issue
Who Does This Apply To?: Customers using SAML SSO configured with auth request signing using the certificate with expiration date of 09/2024. (Customers using OIDC and customers using SAML without the requirement to sign auth requests are NOT affected). Summary: Due to an issue with Domo’s certificate provider, customers…
-
Load and Impact on App - Chart count
Hello, I understand we could create dashboards with any number of charts. However, I would like to understand if there is any ideal count of charts to have in a single dashboard in an App? Also, is there any recommended maximum limit of dashboards in a single App (AppStudio)? Will the limits vary from the type of data…
-
How to handle failure rates (DPPM) when Event is in different month from Sales
I need to calculate failure rates using two different date columns but the Fixed by calculation doesn't work for this. All calculations go by the date field selected on the chart, but I need a Beast Mode that ignores the default date on the chart. For instance, if I want to show units sold by Sales Date but also show units…
-
Dynamic Organization (Span) View
I am trying to find a way by which when a user view the Dashboard, then based on his/her PDP, s/he must see his/her own score and must see his/her Direct Reports entire span/ org score. I have attached a dummy data creating the scenario and along with it I have added Org Chart and the Views that is expected. Any help in…
-
Reset password
As an admin I have to reset one the user's password. I did not see the reset password button where are I found a password change button. Should I use this button only to reset user's password?
-
UI for Dataset ID
Is there any place where I can get the dataset ID information other than the url of the dataset?
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
Sort or Re-Sort Available Values in Variable List
Variables continue to be a game changer for our company. One particular use case we have implemented is to create a variable with a list of all item attributes. As the list has grown the available attributes are no longer sorted in a logical way (for example, alphabetical A-Z). I think everyone could benefit from the…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…
-
Separating words in a column where certain words have more spaces than others
I have a column in a dataset of production data. The column is formatted as follows: Production Cherry Tomato 12x1pt - Packed Beefsteak 15 LB - Restack Mini Sweet Peppers 14x4 FM - Packed I'm wondering if there is a way to pull the "12x1pt" "15 LB" and "14x4 FM" into a column for "Size". Given the varying amount of white…
-
SUM(DISTINCT) or other function?
Hi gang! I've done a mockup here to try and explain what's going on with my dataset and what I want to achieve. The first table below shows my dataset. We don't need the month column for this, but I wanted to include it to explain why each project has multiple rows in the dataset. Essentially, I want to SUM the PlannedCost…
-
Is there a way to track which DOMO assets (cards, datasets, dataflow, etc) uses a specific field?
We found the Card Fields & Beast Modes Governance dataset which shows what fields are being used in cards and beast modes but we would like to track a field name from it's original dataset > name change (if it applies) > DOMO asset.
-
Governance Toolkit
Hi, I am new to the tools within the governance toolkit. I have been doing some research but wondering if anyone has any use cases for, or explanations of the following tools: Dataset Backup: Is this just a safety measure to take before you modify an existing dataset? If so, what would be the difference between this and…
-
Filters on Multiple Pie Charts
I have the following on a dashboard: I want the user to be able to filter the left and right charts using the slicer for different time periods, without resetting one when the other is used. Meaning, I want the left chart to show me FM6 and the right to show FM7. Any ides how I can go about this? The charts are already…
-
Background Image App studio
How to have different Background Image in App Studio for EACH page. I dont want all pages in App Studio having same background Image!