-
Input DataSet - Load New data
I am working on a new dataflow using Magic ETL. I have 11 input datasets. All are Workbench jobs with the Update method set to Append and they each have an assigned Upsert Key. I have configured each of the inputs to load New data. When I save my dataflow 3 of the 11 throw an error. "This data set does not support data…
-
Using Replacement Variable with sql query on workbench
I am trying to use replacement variable with my sql query to append data. I have table in database with about 16 million rows and thus a full replace would not be feasible. I have already referred to KB documentation and my sql query is a select statement with the column name in the where clause as well as order by clause.…
-
Data Dictionary Tool
Would like the ability for Domo to present to me all the fields made available to end users and what they are named (both in display and in the data) and then make available a place for me to define them and expose those definitions easily to end users.
-
Legend right next to its Lines?
Is it possible to have the legends next to its representative lines?
-
Creating a Beastmode/ Dimension
I have a set of data that includes columns like " Facebook Engagements, Facebook Impressions, Twitter Engagements, Twitter Post Impressions, TikTok engagements, TikTok Impressions" how do I create a dimension or beastmode where you will be able to filter by platform, e.g.: Facebook, Twitter, TikTok.
-
Bar Chart Selection Not Filtering Data Card
Hoping someone can help me on this one. I've got a dashboard (below) where I have two charts, one that looks at data across all time, then one to its right that focuses on last 4 weeks. Then I have a detail table below to show results. When the right weekly chart has results that display at least 2 bars, either bar becomes…
-
Amazon S3コネクター・大阪リージョンの追加希望
現状Amazon S3コネクターは大阪リージョンには非対応のため、対応していただきたい。
-
Group two datasets and join them
I have two excel files one includes sales data and line items of products sold in each invoice, the other sheet I have is the freight charges per invoice. I want to be able to sum the freight and sales totals on both sheets and group them by the invoice number on a combined sheet. Is this possible? I sort of started with…
-
Case when and formula with date
I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong? case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0 ELSE `Total referrals` end Note, my date shows as the little calendar and 'Total referrals'…
-
Sum distinct
Hi, i have dataset of products that have repetition item code and quantity, how do i sum the quantity?
-
Beast mode to remove "double quotes"?
I have some strings in a column named Client Name column that include double quotes ("). Need to remove or replace them. I tried using the REPLACE function to replace them with dots like so: REPLACE('Client Name','"','.'). Most things I've found when trying to look this up were more advanced requests and I have not been…
-
Filtering and Adjusting Cross-Month Records in MagicETL
Hey Domo Dojo Community, I'm working with a dataset containing reservation start (RSD) and end (RED) dates in the format of MM/DD/YYYY. I need to identify all records where the reservation spans across two different months (i.e., RSD and RED fall in different months or years). My objective is to filter out these…
-
Need help writing a Beastmode
This is my first BeastMode to create and having some trouble. I am probably way off so just wanted to ask here to save some time. What I am trying to accomplish is to get a sum of current balance of those that are in the groups above 120 Days in the age group column. I'm wanting to Name the Column 120+ Here is my syntax…
-
Ability to Export / Import Custom Themes in AppStudio
Allow users the ability to Export and Import their Custom Themes from AppStudio as a file This would Allow: Custom themes to be portable across instances. If the file were readable text (JSON/YAML/Markdown) it would allow efficient edits via text editor/script, and sharing via code blocks in forums / Slack
-
What does the orange exclamation point mean in the corner of a dataset icon
Looking at datasets in the data section... sometimes a dataset has an orange exclamation point at the top in the corner of the icon for the dataset (see attached picture). when you hover/click on it... nothing happens. What does this mean? thanks, Jeff H.
-
Dynamic aggregation based on user selected date grain
I have a dataset that appends daily to build out a historical view. I want to be able to always show the latest record per date grain based upon the user selected date range and grain. For example, if a user selected YTD by month, then I would want to show the following values from the last day of each month SUM(values)…
-
Yext Connector Missing Data
Hi, I am using the yext connector to bring data into domo and only the google data is pulling in. We have reviews from other sources like yelp but I am only seeing google. Is that how it is designed? Does anyone else use this?
-
Transform Your Dataflows: Discover Magic ETL's Latest Upgrades
Are your data pipelines working as efficiently as they could be? With the latest updates in Magic ETL, there’s never been a better time to fine-tune your processes. Join us on November 21st for a special webinar where we’ll showcase new features designed to help you optimize your dataflows, enhance accuracy, and boost…
-
Table card column borders and padding/empty columns for visual enhancement
In excel, financial statements and schedules often include empty columns to visually separate or group together columns showing different metrics. It would be great if Domo had the ability to insert padded columns in the same way. Currently when you have a table card that displays multiple metrics and variances, it all…
-
Domo APP Button Question
I'm creating a popup button to open a card in the Domo app. Is there a way to adjust the display size of the card so it opens in half-screen instead of full-screen?
-
Move "Data" back to the second item in the Dataset attribute selections
If the reading order on the dataset options indicates the importance of the selection, moving "AI Readiness" into the first spot after "Overview" seems to not track. "Data" should continue to be the most important attribute of a dataset.
-
Conflicts between Global Date Filter and Card Date Filter + Projections
I have snapshot staff data that only makes sense to show on "by year" timescale. I want to forecast it out (by year), but I keep running into conflicts between my global date filters and my card date filters. If I put a "graph by year" on my card, I get logical projections that render on the analyzer and in the detailed…
-
Finding the total data volume queried and storage amount in GB, TB
Hi Domo, Is there a way for me to find the total amount of data queried over a given time frame in GB / TB? I would also like to find how much total space is being used by all the data stored in my Domo instance in GB / TB. Thanks
-
Using FIXED () and Variable?
I'd like to create a BeastMode 'MTD %' that can: Calculate the % of each GL account based of Total Sales Can be dynamically filtered by Month and Year variables Here's my MTD % Beast Mode: SUM(`Amount`)/ (SUM(CASE WHEN `Class 3` = 'Sales' THEN `Amount` ELSE 0 END) FIXED ()) And my MTD Beast Mode: SUM(CASE WHEN Fiscal Year=…
-
Option to have Quick Filter selections DESELECTED by default
Each time a quick filter (selection) is added, all options are selected by default. While you can manually deselect all before saving, it would be nice to have a company setting or other global option to always have quick filter selections deselected by default.
-
How to create a chart with a rolling 12 month by month
Anyone have any ideas on how to create a chart with a rolling 12 month by month. I would like to create a chart similar to the attached in which for each month i have the rolling sum/count. Thanks in advance for your help
-
Domo Stats/Domo Governance Groups dataset
Can we get a groups dataset which includes all of the Groups attributes, ie description. With that said can we get any of the domo stats/domo governance datasets to include all of the attributes of the data. Another example is Reports to on the User dataset.
-
Line in Line bar chart and Multi-line chart does not filter with x-axis value
I have a line+bar chart which has 3 series of data, with one line and two bars. What I observed is: Clicking the dot on the line only filters with the series value, ignoring the x-axis value. Clicking the bar does filter with both series value and x-axis value normally. If I change the chart type to Multi-line, then any…
-
A way to see cards housed in app pages
Hello, I'm putting together an ETL where I can identify if a card is housed in a dashboard page or an app page. The domo stats 'Card Pages' dataset, has been great to see where cards are in dashboards, but I don't see that option for Apps. I've pulled the 'App Studio App Pages' dataset, however, it still isn't providing…
-
An issue has occurred during processing. We are unable to complete the request at this time - 'undef
An issue has occurred during processing. We are unable to complete the request at this time - 'undefined' I was trying to filter the null values in my dataset by choosing column not in null, this gives me the above error and disappears the chart.