-
How to create a dataset last updated card at top of dash?
Hey, how would I create a last updated card on top of a dash? This way it gives the users the understanding of how up to date the cards below are, etc. How would i create that on the dataset to then even be able to apply to a card? Thanks!
-
Remove duplicate unknown comma separated values within a single 'cell'
Hello good people of Domo Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform: If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in…
-
Errors when using domolibrary with client ID and secret
Background and setup: I created a client using developer.domo.com and gave it the "data" scope. I have a client ID and secret now. I have tested it using the PyDomo library and it has worked. However, my goal is to programmatically get and store dataflows as an off-Domo backup. Domolibrary was recommended in another…
-
Comparison for Stacked Bar charts
I love the comparison feature that quickly adds the prior timeframe bar along with a line to show the % change. It would be great if this feature could also be applied to stacked bar charts, with the line dynamically changing when you hover over a specific category in the stacked bar chart
-
Updating Color Rules on Symbol Line Chart
Hello, I am trying to do exactly as was asked in this forum question below. The only difference is that I have multiple lines and many timestamps on the x-axis. Given that this question was asked a bit more than 3 years ago, is there a better way of doing this?
-
Can I dynamically query all fields?
In the javascript for my DOMO card, this is how I am currently querying from my dataset: If I am simply trying to query all the fields in my dataset, is there a way I can avoid hard coding all the fields in the "dataColumnName1" variable, and just change the "query1" variable to dynamically query all fields? Thanks.
-
Spacer cards
Would greatly appreciate a way to add a blank "spacer" card to my dashboards. Currently using empty text boxes to create space, but they have a (pretty large) minimum width/height. Would love a spacer card that could be set to any width/height,
-
Displaying up and down periods over time in a chart
We are tracking internet down time at our stores. Basically every 15 minutes we receive a list of all stores that are currently up. I then process that and for every store that was missing in the list I store a record in a dataset with the store and a timestamp. We need to show over a 24 hour time period what stores were…
-
range filter card should function the same as quick filter
I would like to see this filter card: Have the same kind of display as the quick filter for a range: The dropdown allows for more control, and the ability to type your number in the box rather than move a sensitive slider is really ideal.
-
Removing yesterday data from ETL
Good Morning, I want to remove yesterday, so Day - 1, from our data due to over reporting on the previous day. What ETL tile should I use, I'm thinking there is a formula, but there is also a date tile
-
Card switching using a filter/control in a dashboard
It would be great if there's a way to swap different cards using a filter/control (If I choose category 'A', I want a certain card to be visible and if I choose a category 'B' I want a different card to be visible. (Essentially looking for Domo equivalent of sheet swapping with a parameter in Tableau)
-
Show Federated Redshift Data Source in Data Source Settings
Would be great to see the table or view the federated source is pointing to within the settings of the data source. You can already see and select columns. Currently you have to rely on keeping the location within the data source name.
-
Email connector not updating rows from excel file.
If I upload the excel file via Large File Upload there are no issues. If I attempt to send the same file through an email connector it will either say "Data updated successfully" but have "-" for updated rows and the data does not exist in the dataset. I attempted to re-make a new dataset via email connector without any…
-
I want to understand average sales within 1 year of client sign up
I have a dataset where each row is an individual sale that contains the sale date, client start date, client ID, and sale total. I want to be able to chart the amount an average client spends within X time of their start date where X is a variable that I can alter from the card. Ideally, I'd be able to split the ouput by…
-
Months in card not in order
I have a card for filled positions and it was working all fine. All of a sudden after updating Dec yesterday, the order of the months changed to a random order. I tried sorting the month, but it still did not correct. Any help is much appreciated. Thanks, Gunjan
-
How do you build a Single Value card when using a variable?
I am trying to produce a single value card that shows the number of active employees at a specific point in time. The data set columns included: employeeId employeeFirstName employeeLastName employeeStatus employeeStatusStartDate employeeStatusEndDate (this is null for the current status) locationName regionName…
-
Cumulative Sales between December and January not calculating correctly.
Hello, I'm trying to create a table with daily net sales by date and also cumulative sales up to the current date (1/3 ATM) between two years: For the "Date" column, I used a beast mode to create date index formatted as %m/%d value: CASE WHEN YEAR(`created_at`) = '2024' AND DAYOFYEAR(`created_at`) <= DAYOFYEAR(CURDATE())…
-
MoM Variance in Pivot
Hi All is there a way to display the MoM Variance values in a pivot? for context i have data per day for Company, Division, Subdivision hierarchy, i can easily display the values at the end of the month in the hierarchy state but what i would like to do is calculate/display the monthly movement with the ability to drill…
-
Please add scheduler to domo Google Sheet extension
This is an awesome feature. But I really need the data to automatically refresh.
-
Salesforce Advanced Connector Add New Fields
Ability for the Salesforce Advanced Salesforce connector field options to allow auto adding new fields like the other Salesforce connector.
-
How to calculate % change between these two years in a beast mode on several columns of data?
-
Business Days
Hello all! I noticed a post or two discussing that there was a Business Days or Workdays-type function in beta and I am wondering if there are any solutions to finding the number of business days between two dates until this solution goes live? My data is fairly straight forward; assuming two columns [Date 1] and [Date 2]…
-
Suppress Card Preview in Alert Email
We are alerting on a card that shows data in a tabular format. One of the columns in the card is sensitive and shouldn't be sent over unencrypted email. But the value is contextually important for the person receiving the alert. I can think of a half-dozen ways around this. But what I really want is the option to disable…
-
Domo CLI or API to Automate Script for Permission Management 1000's of Cards, Pages/Dashboards
I have 1000's of CARDS and PAGES / DASHBOARDS that I need to script to automate removal of shares, permissions or add share permissions? Are there any API or Domo Util Tool CLI available for this? Thanks.
-
Dataflow feeding which dashboard
Good Morning and happy new year, Is there a way to see what dashboard a dataset is used on? thank you!
-
Add a Blank Column
Hello, Is there a way to add a blank column as a sort of place holder in a Table Chart Visualization? Thanks!
-
Dataset reference in Python by identifier instead of name
To identify input dataset by identifier instead of name, very useful for working with Python modules, as right now you need to update the source code when changing a name.
-
Surveymonkey Advanced Connector - enhancement request
Please change these to searchable menus - especially the Survey menu. This shows all surveys a user has EVER had access to in Surveymonkey (even if they are closed/removed from access inside surveymonkey.com), and it can take ages to scroll through and find the survey needed for reporting. A searchable list would be ideal…
-
Which Connector to use to auto update excel files?
I have several excel files that automatically update daily with the same name. I want to get the data to Domo. I was using File Upload Connector, it doesn't update when the excel was updated. (I tried using File upload connect with an excel by deleting and adding several rows, clicked update through setting, but the…
-
How can I update row values for col1 based on the common ID in col2
How can I use MagicETL to update the rows with NULL Source values to have their relevant Source value, based on ID? Starting Table ———————- Source | ID | RankCol ———————- plant | 100 | 1 NULL | 100 | 2 animal | 101 | 1 NULL | 101 | 2 Desired Resulting Table ———————- Source | ID ———————- plant | 100 | 1 plant | 100 | 2…