-
where to find the append/replace feature for a google sheet in DOMO dataset?
for a spreadsheet, I can find "Append" under Settings - Update Mode as below picture. for a google sheet, why there isn't a Append as the update mode? for example, today I have "2.28" worksheet data uploaded into DOMO dataset, tomorrow, I want "3.01" worksheet data to be uploaded, and so on. every day I upload one…
-
Badges Tracking Gauge in Profile
For the non-reaction, tiered badges, like 'Accepted Answers' and 'Upvotes', there's not a clear and easy way to see how one is faring. It would be cool to have a gauge meter or tracking bar for each milestone in those two categories.
-
Tool to convert MySQL data flows to Magic ETL
In order to take full use of the power Magic ETL v2, it would be great if a tool could be developed to take a MySQL data flow and convert it to Magic ETL
-
Can't seem to sort the dates on the X-axis
Hello, I have 2 cards next to each other. One has a date field in the dataset already and another one date is calculated like this DATE(STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d')) where the field "Date + Hour" field looks like this Even though the calculated field shows as type "Date" the chart sorts it as if it was a…
-
Dataset Color Rules - lock color to column regardless of rules
Much of my data compares KPIs across 30+ different cities. When I use city on series, the colors are assigned in the order they are charted. So if I'm charting A-Z, the first in the alphabet gets for instance light blue. If, on another KPI, the default sort is by value high to low, the colors are completely mixed up.…
-
Optimizing Google BigQuery Service Connector
We are currently funneling our Google Analytics 4 (GA4) data into BigQuery, and then connecting to BigQuery with 'Google BigQuery Service Connector' in Domo. We are partitioning using date keys and bringing in the past 3 days of data (to account for attribution in GA4) with an append. However, our daily updated rows ranges…
-
Copy Page to Another Tab in App
Would love the ability to duplicate an entire page within an app and put it in another tab.
-
Support Unicode in CSV
Currently Domo does not implement Unicode in exported CSV. As a result, some languages and characters are not recognized when the CSV is opened with Excel.
-
Compare against a specific date?
I have a dataset that aggregates data on a daily basis. I would like to compare the most recent value to the value on a specific date. Example: Date Value 1/1/24 400 1/2/24 403 1/3/24 410 …. 5/7/24 500 In my Multi Value card, I am using MAX of Date and Value to pull the value 500, then for comparison, I have the all the…
-
2 Obstacles to Achieving Automated Reporting - asking for help
3PL send me daily storage data. In the file each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report with each day's data in different sheet. I'd like to connect this daily…
-
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
-
How to get the first character of a string in domo beast mode analyzer
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: TRIM(ProductNumber) Next I am trying to use the Left function to get the first letter from that test field without any extra…
-
How come MySQL does not support window function, specifically lag in dataflows?
Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window…
-
how can i track remote domo stats available in my child instances (05875821)
apparently remote domo stats have to be enabled on a per request basis (ticket 05875821) if i have 100 instances, what would be the most expedient way of confirming that all of them have the same stats reports available? if Domo updates a version of the report (and modifies the schema or how content is generated) what…
-
how to change the type of existing DOMO data?
data has been uploaded into DOMO. the first column is in integer type like '45319' but actually it is DATE(Jan-28-2024), how can i change it to DATE in DOMO without changing the original spreadsheet data type? thanks
-
Confluence Card
Hi all, I heard something in DOMOPALOOZA24 about having a card with Confuence content, does anyone know anything about this? I couldn't find a connector or anything… The idea was to have a card with the dashbboard documentation that lives as as Confluence page. Thanks!
-
Remove lookback period from the data and see the values.
I have a dataset which holds transaction data. I have dates, i have derived a week column from date which has values like “2024/17”, etc. and I usually filter data based on weeks. My use case is when I select a week using 2 variables- one will pick year and other will pick week number, I want to subtract lets say past 4…
-
Connect Two Cards
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
-
Mexico city zipcode map in DOMO
I am looking to add a custom chart for the city of Mexico on Domo based on zipcodes (supported file format - svg, GeoJSON, kml) . Please share if anyone has any reference links. Thanks in advance.
-
Charts on distinct values
I have a dataset, which is the result of a join so the ID is not a unique key: +————+——————+——————-+—————| | — ID — | — Name — | — Gender — | — Role — | +————+——————+——————-+—————| | 001 | Alex B | Male | User | | 001 | Alex B | Male | Admin | | 002 | John C | Male | Agent | | 003 | Drew H | Female | User | | 003 | Drew H…
-
Want to track progression and targets based per Quarter
Hi all, I've one datafile with sales with different products. Quantity is a column where I used 'sum' Target is made through a beastmode 'case when QUARTER(date) like 1 then 1250 else 0 end' Progress v2 is also made through beastmode and doesn't deliver the right results 'QUARTER(date) like 1 then (1250- (quantity)) else 0…
-
Microsoft Forms and/or Customer Voice Connections
We currently utilize SurveyMonkey for some of our internal surveys; however, we are looking to transition away due to the increasing cost and instead leverage some of our 365 products. We were looking to move to either MS Forms or Customer Voice; however, I'm not seeing a direct connector in Domo to pull data. I know I've…
-
How do I append data to a designed CARD every day automatically?
I set up a CARD to show warehouse storage location quantity, every morning the 3PL send daily storage location report, I'd like to append the daily data automatically to DOMO from google sheet because 3PL's report is in google sheet format. How can I set up it? Thanks a lot.
-
Choosing first and last month in BM
Is there a way to use fixed functions or something else to grab the first date that appears and the last date that appears? I am trying to calculate yearly attrition. I have it by month but adding up or avg the monthly % is not mathematically correct. I need to get the first month and last month's values within a certain…
-
Filtering data with 2 columns with beast mode?
Now I have a dataset something as below; ID Cat Name Cond01 0001 1 A 3 0002 2 B 4 0002 1 A 3 0001 1 D 1 0003 2 B 7 0003 1 C 5 0004 1 A 9 … … … … Now I want to make two filter cards to select data by Name , conditioned with a Cat value, where one card is for filtering data by Name when Cat = 1, another one by Name when Cat…
-
UTC to PST conversion in ETL
Hi, I am trying to convert the "Date" from UTC to PST in the ETL. Currently, I created "Send Date PST" with the formula below. TIMESTAMP((convert_tz(`SendDate`, 'UTC', 'America/Los_Angeles'))) However, when I try to use it in the card and filter for the last 4 hours, my card is blank: It works when I do the same thing with…
-
Using regexp for pulling multiple values out a text string
Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!
-
Step Ratios - Pivot Table
I have a pivot table showing total number of applicants through the recruitment process. I want to be able to show the "step ratio". Pivot Table has Steps in the rows, column is job type, values are a distinct count of candidate ID. Dataset has multiple rows per candidate, each step of the process they've reached. Im…
-
Embed error, duplicate of dashboard does not work
We're getting an error returned based on the embed we are trying. Private embed. Embed: https://public.domo.com/embed/pages/gJ6z3/stack?parts=metadata,datasources,drillPathURNs,domoapp,slicers,dateInfo&includeV4PageLayouts=false Error: {"status":404,"statusReason":"Not Found","toe":"1T0CBEN7LS-682ON-K3KSH"} this one…
-
Case Statement - 28 Days from a specific date?
Hi All, I need to write a case statement that would calculate 28 days from a selected date. How would I write that? The end result would be total sales within the 28 days going back in time from the date selected. Thanks, Paul