-
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!
-
Finding Statistical Significance for A/B Testing
Hi there, I have a dashboard for reporting on the results of my A/B tests. You select what experiment you want to look at from the filters, and the KPIs are populated for each variant, as well as a Lift/Decline for different metrics which is calculated through different Beast Mode Calculated Metrics. My question is, is it…
-
Background Image in App Studio
How to change the background in App Studio for EACH page. I DONT want my page to have same background for the whole page in App Studio. Not convenient at all cannot use different background image
-
Offset DATETIME Data Based on Personal Time Zone
The documentation (https://domo-support.domo.com/minasan/s/article/360042934394?language=en_US) states that Updating your personal time zone doesn't offset any DATETIME data you are viewing in Domo to display in your personal time zone. Only the company time zone offsets any DATETIME data. I'm really puzzled by this. If…
-
Globally assigning Beast Modes back to Datasets rather than just to cards
Maybe this is WAY out of scope, but it would be helpful if there were a way to globally "reassign" card-level Beast Modes back to their source datasets, or at least to somehow trigger ONE copy of a card-level Beast Mode that is replicated across multiple cards back to the SOURCE dataset. Perhaps I don't fully understand…
-
Grouping beastmodes from different datasets in beastmode manager
Is there a way to group beastmodes from different datasets in the beastmode manager? In our instance, we have multiple datasets that serve different business purposes but have the same name and beastmode formula. If we can group them together as one in the beastmode manager, it would not only better organize the beastmode…
-
Parameters Defaulting to First Option when Published.
I'm having an issue where a specific parameter will default to choosing whatever is first in it's DROPDOWN options list when it's published. It works perfectly when in the Custom Connector Builder, but when I self-publish, the issue arises. What's causing this?
-
Domo Workbench Writeback Provider plugin has expired
Hello, I use Domo Workbench Writeback Provider Plugin to automate process to move data from domo to oracle table. Process of using Domo Workbench Writeback Provider was working properly until yesterday when I get message that Domo Workbench Writeback Plugin has expired. How do I make this Write Back provider permanent?…
-
Pivoting multiple columns with the same column values as its values
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
-
Changing the input datasource to multiple ETLs at once
I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the…
-
Does running an ETL with a schedule change the future run times?
If I have a flow that is scheduled to run every two hours, and I do a manual run between those times, will the next run happen two hours from then or continue on the original schedule?
-
Export Domo Data to Network Folder
I am looking for a solution to export a table automatically from Domo to a network folder. Is it possible? If so, how to set it up? Thanks
-
Dynamic Conditional Formatting
Current conditional formatting is very useful, however still quite limited in functionality especially with numeric and date values as these are static. A current workaround for this is to utilise HTML tables, or create additional columns for above/below the required targets, which gets quite messy. It would be hugely…
-
Dynamic Date Range Comparison Using Variables
Hi there, I recently saw this video on DOMO Variables from Zack Cameron and around the 17:30 mark he's using variables to control the Time Range (YYD,QTD,MTD,WTD) and Time Comparison Option (YoY, PoP). This functionality would be perfect for the dashboard I'm building out, but I'm having trouble recreating it. The code for…
-
Domo Documentation
HI, with the aim of having in-depth documentation of what was developed on Domo for a client, I need to have detailed documentation of all the objects created. In detail: Card: in addition to the details that can be extracted via the DomoStats and DomoGernance connectors, it would be of interest to have greater details for…
-
Grouping and ranking data question
Hi. I have minute level data i am dealing with. I am trying to get total minutes that a post is open during a day. It can be post 1, post 2, or no activity. I am grouping by Date (Day) and Post then doing a difference between then Max and min timestamp to get total minute sin the post. This is how I want my data output to…
-
Single column dynamic pivot - syntax error
Grateful for any guidance. I'm seeing the syntax error below and I can't figure out why. New to MySQL Transforms as my previously relied upon python scripts are to be deprecated. Objective To take a single column of dates and turn them into column headers. Once pivoted, row value(s) are irrelevant (they'll be overwritten…
-
User view time in a domo page
Can we extract how long a user has viewed a domo page.
-
Dataflow was saved, but could not run?
Does anyone know why I would this error when updated my ETL? I update this report each week, and received this error. I even defaulted to reports that have worked in the past. Is Domo having any issues today?
-
Form builder limitations and development
Currently, the form builder has only three predetermined font sizes. This limitation makes the 'explain your response' box too small to notice the text written in it. It would be nice to have options for custom sizes and format changes. The multiple selection checkbox is hard to identify because it looks like a…
-
Data Labels with Period over Period Charts
Hello, New Domo user. I am trying to add data labels to charts using a PoP chart. I jsut want to show the total numbers above each bar chart and the data labels setttings doesnt have the option to show the labels. Seems like an easy thing I can't find but I just cannot find it…
-
Using Regex in ETL to check if a string ONLY contains digits?
I found that using the expression REGEXP_LIKE(field,'^[0-9]') will check if a string contains any digits. What I'm struggling to figure out is how to flag whether it ONLY contains digits and no other characters.
-
Which connector to use for Oracle
How can I setup a path for Oracle to access data from DOMO? There is a table in Domo which I would like to share in Oracle. Thanks
-
Smart text not displayed in Powerpoint export
Could you please help me with this? Analyzer Power Point: In addition, I want to show the name of the month for the Date Range instead of: Previous Month. Is it possible? Thank you
-
Can a Workbench be used to export data
Can I use the workbench to export Domo data to Oracle?