-
Standard / Fiscal Calendar Variable Switch
For instances where fiscal calendar has been enabled, having the ability to switch between standard and fiscal calendars as a variable control would provide another great level of flexibility. Currently customers who want to do this either need to have two seperate sets of cards - one with standard, and the other with…
-
Find Employees Manager Manager
Good Afternoon, I have a dataset that has EE#, lastname, firstname, Manager, ManagerEE#, ect…, and my question is I need to find the employees Manager- Mananger; all of the employees are listed but there is no column for Manager's Manager. How can I do that in an ETL to create a new column. Here is an example of how I want…
-
How to apply filter to card that is always showing the most recent dataset update?
I have a dataset that is aggregated by a calendar week number. How could I ensure that when a user goes to view a respective card, that they see the most recent week (even if the dataset hasn't updated in 2 or 3 weeks?) i.e. the user views the card in week 15 but the dataset hasn't updated since week 13. So I would want…
-
Auto Data Replace in Drill Down Cards
We build of a lot of drill down cards however when the cards are duplicated, we would update the dataset of the parent card however this does not automatically update the child / drill down cards, it still maintained the original dataset it was duplicated from. There should be an option to replace all the child and drill…
-
Can you turn off the hover value on a radial gauge?
I'd like for this not to show the $11.64. Seems like it's not possible. Can anyone confirm?
-
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.…
-
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…