-
How to remove all grid lines except for X & Y zero lines
The subject pretty much lays it out. I want to remove all gridlines on the visual except for X & Y zero lines. I use grid lines sparingly, especially on scatter plots, but sometimes I want to include the specified lines for esthetics or whatever but can't seem to figure out how to accomplish that. The closest I can get is…
-
Slack Data Connector
Has anyone created a dashboard from the Slack data connector that could share their experience?
-
Alert for Field Name Change (within a column)
The current set up involves a dataset that is updated once a day and this is then uploaded to DOMO for further use. If a field within a column is changed and there would've been cards that are filtered on this very specific field within a column, the cards will go blank. Has anyone counteracted this? Please bear in mind…
-
Convert a time to a number
I have a user that has his own dataset and I am converting it so that it is all done through an ETL but the issue is that he has a Average Handling time of 06:32 but he wants to see it as 6.32. I am have had to convert the times to decimal to work and then covert it back to time doing the following: SEC_TO_TIME(…
-
Variable connected to a Filter Card
Part 1: I created a variable that allows me to select a different field. I then use this variable in a control on the dashboard. Part 2: I am trying to use the control I created in part 1 to change one filter card that is connected to this variable. The goal is to have one filter card that changes based on the variable…
-
Datasets Running Twice with a Small First Run
For some reason datasets are running twice with an initial small run of <5 seconds that is considered an "API update". This affects ETLs which have their trigger set on "when datasets update" as well as alerts. What happens is that the ETL starts running off of the 2s dataset run above, after which it will run again when…
-
MTD Last Year, YTD, YTD Last Year with Rank & Window Tile
Say my dataset has these columns: branch_id, gl_id, amount, Month End Date, fiscal_year, Month Number I'm trying to recreate below SQL Window function with Magic ETL so that for every Month End Date*branch*glid combination has a corresponding MTD Last Year, YTD and YTD Last Year. SUM(amount) as 'MTD' SUM(SUM(amount) OVER…
-
Uploading Excel - Data Type Issues
When uploading an Excel document, where all of the data in the columns are formatted as "text", DOMO will change the data type to number, every time I upload it. I know there is an option to change the data type using MAGIC ETL, but here is my problem. In our data we have account numbers with preceeding zeros, for example…
-
December Community Recap
Hi Domo Community! It was an exciting December and I hope each of you are ready for a new year! Check out our December recap, as well as this month's CMM. Feel free to like, agree, upvote, and comment on discussions you find helpful. Postitive reactions give points to the author to help them rank up. Catch up on the latest…
-
Data Freshness - Cloud Amplifier (Nov 2024 Release)
In the recent release Domo announced Freshness Check for Cloud Amplifier integrations. This tends to work perfectly fine for Snowflake Datasets and updates the data on the scheduled intervals but does not reflect 'Last Updated Time', in the Overview tab of the Dataset. [This was posted by DomoSupport, on behalf of a Domo…
-
Filter visualization on dashboard help
I have a dashboard that I added a donut filter to at the top containing Category A and Category B. Below it, I have a single bar chart with no series that shows the amount of new paid companies in a given week. At the bottom of the dashboard, I have a standard table with the complete list of companies. The intended…
-
Calculating country from lat long - latitude longitude
Hi, I have a data set containing lat long information, but I need the country information. Any idea how to calculate that in an ETL or Beast? I see there are lat long maps, which show the country information correctly, but I would need that in my table. Example: Location Longitude Location Latitude -149.5485 -17.7538…
-
Have Smart Text show exact time dataset was updated
By default, smart text shows the relative time a dataset was updated. For example, Dataset A was updated: 7 Hours Ago. Is there a way to display the exact timestamp instead of the time elapsed since the dataset update?
-
Have Smart Text show exact time data set was updated
Pretty straightforward. I want to show a datetime stamp instead of a relative time for the Smart Text that tells when a data set was updated. This is super annoying when users want to screenshot/export/whatever.…
-
App Studio Utilisation
It's surprising to discover that there is currently no method to track the utilization of apps created through App Studio. We need a mechanism to monitor this in order to determine whether the apps are truly adding value to the business and whether they are being used effectively. We need this asap as we see so far 290…
-
beast mode formula: Previous week compare to same week last year
Hi, I am struggle to get a beast mode formula to work for calculating the sum of same week last year, our business date start from Sun- Sat, i want to get the formula to only calculate previous week data e.g. today is 24th Wed but i want to calculate the week from 14th Sun -20th Sat DOMO says the formula for LY is…
-
YEARWEEK Function and Modes
Hello all - I am looking for some help with the YEARWEEK() function. I see that the function syntax is: YEARWEEK(`dateCol`, mode) where 'mode' defines the starting day of the week with '11' meaning Sun-Sat and '22' being Mon-Sun. I found this in the Beast Mode Functions Reference Guide but it doesn't expand whether other…
-
Duplicates
Hey guys, I'm experiencing duplicate fields on my data grid and trying to figure out how to remove them.
-
Filter on Job name in the workbench5
I have about 500 job in the workbench. Is there a way to activate the filter on he job name column so that I do not have to browse through every row? Thanks
-
beast mode question
Hello everyone, I'm having an issue trying to get this beast mode calculation validated. We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs. And we want a color change when ticket is about to breach 4hrs with no update. I wrote this but getting syntex error. if…
-
Unable to Use SSO for Domo Mobile App in Intune MAM Environment
Domo Mobile App is not listed in "Microsoft Intune protected apps" and cannot perform Single-Sign-On with Microsoft Entra ID on mobile devices managed by Microsoft Intune MAM. Therefore, our employees are unable to use Domo Mobile App. We strongly hope that the Domo Mobile App will be supported by Intune MAM.
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
Why Is the Pivot Tile not Working as I Expected
I am trying to use the Pivot tile to accomplish the following (in my attached dataset), but am getting no results under the column I am creating (Weekend_Date_Pivot). Weekend Date should now be columns with Demand_Qty as the metric under each Weekend Date
-
Company Lookup on Different Columns
Hello, I am seeing if there is a way to write a beast mode that'll allow a user to input a company name that searches across multiple columns. For example, I want to look up Wells Fargo as the company name. I have three columns where Wells Fargo can appear under: Buyer, Seller, Lender. Is there a way to allow users to type…
-
Multiple dashboard filters
Hello, I have 4 dashboard filters on my dashboard.. Is there a way that once I select the first filter (for example account), that the other filter dropdowns are filtered? The issue is that the dropdowns are showing only the first 50 ish rows of data. So if I'm able to use the first filter, to filter down the data, that'd…
-
I am trying to delete a row from dataset
Filter rows in Magic ETL gives a new dataset with the filtered rows but doesn't delete it from the input dataset. I am trying to update the input dataset.
-
SMART or FORMULA BASED NAMING AND COLOR
2 ideas here… SMART TEXT OR FORMULA BASED (CONDITION BASED) NAMING This would be for columns or labels on charts. Instead of saying This year… it could say 2025 for example and change dynamically as the years change instead of having to manually change them in the system. FOR COLOR RULES: I would suggest having more…
-
Can I use a Beast Mode for Null/Blank Values?
I have two issues I am trying to solve. Company123 has a budget of 706.34, but there was no $ for this week. The cell is blank, so my formula is not calculating. The Budget GP-GP should equal -706.34, but it is blank. Can I do a Beast Mode, or even something in the ETL would be okay? Second issue is the 27,504.75 minus…
-
How can I set up a graph to show period over period data in a dynamic way?
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
-
Optimizing a Domo Workflow for Sending Emails Based on Dataset Markers
I’m working on a project that involves sending emails to individuals based on specific markers in a dataset. Currently, I’ve set up a Domo workflow that iterates through the dataset row by row, checks certain conditions, and sends emails accordingly. While the workflow functions as intended, it is extremely slow. To…