-
Date_Sub
Hi, I have two dates that are timestamps ex(dec 12, 2023 6:30:00 Am) I am trying to subtract the two dates to figure out how long a certain task took to complete. I am using date_sub and I am receiving this error, how would I fix this? "Calculation Error : Operator '-' cannot be applied to type 'Timestamp'."
-
Need an option in our domo instance to have user specific timezone.
We need an option in our domo instance to have user specific time-zone. If a user is in EST time zone, he/she could see have an option to view the date according to their time-zone rather than a universal time zone. Example: Run time of any dataset is 9PM IST but someone from EST time-zone could view the dataset run at…
-
Is there a way for a DDX brick to go outside of its frame?
Looking for a solution similar to the way the dropdown filters work in dashboards, where a card/brick can have a fly out or content extend past the frame of the card in a dashboard. For instance, a small calendar widget once clicked expands into two full month views past its frame, but doesn't take up much dead space on a…
-
ANNOUNCING SKI DAY: Join Us In Person for Domopalooza 2024
At this year’s Domopalooza, we’re making “aha!” moments happen everywhere—even on the slopes! Round out a week of insights and entertainment by joining your peers on Friday, March 29, for a fun-filled ski day at Snowbasin Resort! Registered attendees need nothing more than a valid ID to qualify for a complimentary lift…
-
How to count numbers in an email address
I am trying to identify email address with more than 4 numbers occurring before @. I tried the following code CASE WHEN LENGTH( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(…
-
not able to initialize a variable in conditional gateway
when i am using conditional gateway in readymade template of ask your manager it is saying to initialize my variable 'doesmanagerapprove' which is a boolean data type. what to do , how to initialize
-
SORT on Pivot Table not working anymore
Hello, since a few days I have Pivot Table cards that dosen't let me sort them using the little 2 arrows in the column header ? Was working fine and then stop working. When I convert the card to mega table, it work. I'm I the only one with this trouble ?
-
Keep Columns After Using Group By Tile in ETL
I haven't played around with the group by tile yet so this might be a very simple answer I overlooked. But why do all of my columns disappear and leave only the columns I identified in the group by tile from my data after I use this function? I know I could join the data back in but I was assuming I was using it wrong.…
-
30 Day Interval
Hello! I am looking to create a beastmode that sums video views and revenue separately in the 30-days after the asset is published. While the beastmode is validating and looks to be calculating accurately, the QA is very off. In the screenshot example, I manually filtered the time frame for 30-days after the published date…
-
Run Recursive Dataflow only when new data comes
I am trying to create a recursive dataflow which should run only when new data comes. Here are the conditions for that, We are suppose to get weekly data in our CSV connector every Monday. We have set out recursive dataflow to run on Wednesday. We use week number as our constraint column. But sometimes, we get data late on…
-
5 Job Openings for Domo Users: February 26- March 3
Hello Domo community! If you're looking for a job that uses Domo, look no further. We found five job postings that mention a need for well-versed Domo users. Nestlé USA - Senior Analyst Digital Marketing Analytics - HYBRID As part of the Center for Marketing Excellence, the Senior Analyst, Digital Marketing Analytics will…
-
CSV SFTP Push Connector Error
Hi all, I am asking a third-party to push a dataset into DOMO using the CSV SFTP Push Connector. They have tried to push the data on two separate dates and both times we are seeing the error message, "Domo system error encountered processing your data. We are working to resolve this issue (Temporary Internal Connector…
-
Dataset TimeZone Select
Hello, Having a dataset timezone select would be amazing so you do not have to convert all of your dates one by one. Would be great to set the dates, within the dataset, to the timezone you wish and then have it convert to your company settings.
-
SQL Query against dataset
Hi, I am wondering if anyone has ever had a ask for a way to just write sql against a dataset, or join to datasets. I know we have redshift, but this would be more like a SQL IDE you would use in a relational database. I know its kinda an odd question, but we have some users who prefer sql vs magic etl. I have seen the AI…
-
GA4 Sessions & Total Users Ingesting Incorrectly
I am trying to ingest Sessions (Sessions and Engaged Sessions) and Total Users into Domo via the GA 4 Connector. We can get New Users and Events to ingest into Domo correctly. I have tried to bring the data in alone (no dimensions) and with additional information (2-9 dimensions). I have also tried each metric separately,…
-
Update values on visuals based on a filter value calling an API and returning an API response
Hi, So let me elaborate on my use case. I need to allow for real time updates being called from an ML model API to be shown within Domo - as per my understanding this would require the values on a certain KPI visual I have setup to be updated when I move sliders across another control which should call an API and return an…
-
Default - Open card in new tab
Can we please have this dashboard/card property as a default? 99.999% of the time, I want to open the card in a new tab so the user doesn't leave the dashboard. This won't apply when using the expand details button, which is also a nice way to get a closer look at content — but sometimes you just want to pull that card…
-
Change instance week start day on default calendar
It would be amazing (and needed by lots of our clients) if we could modify the behaviour of the default calendar. Lots of our clients have a financial year but also report on calendar years. The default calendar in a domo instance is calendar year based but the start day of the week is a Sunday. It would be good if in the…
-
Rank Top 5 of the week
I am trying to solve 2 things and would really appreciate your help. When I take out the Sorting filter for SUM of Quantity and Fiscal Month with week (No Aggregation), the number of quantity changes, and the number of products per week also changes. This may be a data issue but is anything odd in this card? Before: After:…
-
Is it possible for two people to have admin access to the Domo Workbench?
-
DataSet Scheduling Hub
It would be nice to have a centralized place to view and manage the scheduling for all existing DataSets.
-
Domo Workbench Error
I have an Excel file that gets picked up using Domo Workbench once per week. Workbench is showing an error, "Cannot read that as a ZipFile." The file is not configured as a zip file. It's a local Excel file. And it's configured to load as an Excel file (Excel: On-Premise). I opened after seeing the error and it opens in…
-
TimeZone selection in connector set up
We are using the ServiceNow connector. Our Company time zone setting is on ET. When I compare data record time stamps within ServiceNow compared to Domo, Dome displays date information 5 hours behind the actual time shown in ServiceNow. While we can convert the date/time to correct within beast modes and dataflows, it…
-
DomoStats - User Level Page Views History
We have a need to dynamically display to each end user their most visited dashboards and we do so by collecting how often they visit a page and also by a pages last accessed date. However, this data is always a day behind because the only place that records this data for a user is stored is in the Activity Log Governance…
-
Choose What Cards to move to a new dataset
The functionality to move list of cards from one dataset to another is great, but it would be even better if you could choose exactly what cards you choose to move instead of all or none.
-
Favorite Datasets
It would be very helpful to be able to "Favorite" datasets like we already can with cards and dashboards. This would make it easier to find your most used datasets when building cards, especially with similarly-named datasets. While it is possible to accomplish this using dataset tags, it would be challenging to manage…
-
What are the best practices/recommendation for displaying dashboards in the users primary language?
We are expanding our services to Puerto Rico and will need to provide dashboards, scheduled reports and visualizations in Spanish and potentially other languages. What tools or best practices have been used within Domo to support multiple languages.
-
Need DomoStats connector to allow for quicker update times
The DomoStats connector only allows for updating datasets daily. Having update times as quick as every 15 minutes, etc would allow for more impactful reporting when building exception/alert reporting as well as trending analysis.
-
Notification on Domostats dataset failures
I just saw that some of our domostats datasets had not been updating for almost 30 days. I discovered this because I was alerted that some had just been deactivated for failing for the last 30 days. I use the user dataset and the activity log dataset to boot inactive users. I need a notification when the dataset fails, not…
-
What exactly am I supposed to submit on a MajorDomo Practical Test?
This might be a stupid question, but I can't seem to locate any exact instructions on video recording for the Domo Professional Practical Test. I'm currently on the path to becoming a MajorDomo. I've just passed the Domo Professional Knowledge Test. I understand that I am supposed to screenshot each card, as well as…