-
Magic ETL dataflow not running because of no change in data
Hello, So, I created a magic ETL dataflow that selects a row from a calendar where the shortdate=Current Date and I scheduled this dataflow to run at 6am daily. The dataflow has not run once becuase it states the following: Your DataFlow was last triggered on 4/3/2019 6:00 AM but there was no change in the data, so it…
-
Zoomed in chart with arrow
Sorry if this is a basic question but I have not been able to find the answer anywhere. I have one chart that displays the chart zoomed in with a blue left pointing arrow which when clicked will display the full detail of the chart. I would like to have this functionality on other charts but I cannot seem to find what…
-
Exclude Categories that total 0
Hello, I am looking to exclude categories on a pie chart when the total for that category=0. I tried creating a couple different beast modes using sum(`revenue`) over (partition by `department`) but they either do not work as a filter or break the card. I would like this value calculated on the fly because the date grain…
-
Adding Cities/Points of Interest to maps
I was wondering if there was a way to customize which cities are displayed on the maps. My bonus question is whether we can add points of interests to the maps as well. Thank you in advance.
-
Custom Summary Number
Let me preface this by saying that I use custom summary numbers on a lot of cards and I format the html to include colors and symbols so I feel a little embarassed making this post. Recently I have custom summary numbers that will not work on one dataset but work on another. For the life of me I cannot figure out why, so I…
-
Google Analytics Connectors
I am attempting to use the Google Analytics or Google Analytics Enterpise Connectors and whenever I try to create a custom report I receive the error "Selected Dimensions and Metrics cannot be queried together". I can make a successful connection and import data but only by removing metrics and dimensions one by one and…
-
Date Selector Card - Default Value
Does anybody know if there is a way to set the default value on a Date Selector Card? My situation is that we have a few YOY comparison cards on the dashboard at the day grain. Most users look at the dashboard for the previous day and also current/previous week. If I set the card to current quarter or current year then the…
-
Interactive Date Filter Card
I created a date filter card but I do not understand how a user can select the Presets when the mouse over covers the card with the wrench menu. Any advice?
-
Magic ETL - filter with not in
Please forgive me if this is a stupid question but until this point all of my dataflows have been in mySQL or Redshift and I am trying to utilize the Magic ETL where possible looking for performance gains. Common scenario is to get a list of accounts and use that in a where clause to exclude those records from a result.…
-
Historical Comparisons
Hello, We have completed our 2nd full year in Domo and we are starting to see performance issues with the dataflows. We have been integrating data sources left and right and our instance is around 500M rows. Not sure if that is typical or not but it should give you an idea of the data we are processing. Some of our…
-
Extracting time from datetime stamp
I am trying to extract the time from a timestamp in a redshift dataflow and cannot get the hours to extract correctly. My datetime field is in UTC and I need to convert the time zone to EST which is fine but when I try to get the time from the time stamp it returns the hours of the UTC time and not the converted timezone.…
-
PDP based on multiple columns
Each row of my data can identify a type of transaction up to 6 different ways. Example shortened to 3 transaction type columns: cheeseburger15.25food t-shirt19.99retail combo pkg199giftcardretailfood I want to create a PDP policy that allows a group to view all food type transactions. The policy would need to say if…
-
Insights Feed
According to the new release notes the Insisghts feed can be customized for "you". Exceprt from release notes - You can tailor your feed to show you the most meaningful Insights and NLG Analyses by rating each one using a "thumbs up" or "thumbs down" icon. My question is whether "you" is the user or the instance? Will each…
-
Update Method option on dataflow
So I was editing a redshift dataflow this morning and I noticed a new option on the output dataset named Update Method. It has a replace and an append option. I am not sure when this became available or how it should be implemented. I understand that all current datasets replace themselves and normally to append you need…
-
Table Card Total Rows Incorrect
I am trying to create a table card summarizing this data by Date and Department: Summarized the table looks like the following: How can I get the total rows to be correct on the card? I want the ability for the user to be able to drill down into a department and see a list of employees. Thank you in advance for your…
-
Grouping/Filtering
Hello, Our main POS system allows salespoints to be assigned to salespoint groups. Salespoint groups are a commonly used filter in our reporting outside of Domo. One salespoint can belong to many salespoint groups (some belong to 8 or more). Outside of Domo I would setup a salespoint group parameter, retrieve the list of…
-
Deleting Beastmodes
I am almost 1 year into using Domo and am in the process of trying to clean up cards and datasets and would like to remove old beastmodes. I am having trouble where Domo is telling me the beastmodes are in use on cards that I cannot find or access in my instance. I am an administrator of my instance so I should be able to…
-
Quick Filters
Hello, For some reason when I edit a card my quick filters change from "In" to "Not In". Whenever I edit a card I need to verify my quick filters have not changed. Anyone else seeing this behavior and is there a way to prevent it from happening when a card is edited? Thanks in advance for your answers!
-
April 2018 Release
Yesterday I was teased with pop ups showing new release features such as dataset tagging and viewing sql execution plans but I do not see any of this available in my instance and nothing under the Release Notes yet. Was this just a tease or should these features be live?
-
Page Filtering on a Beast Mode
Does anyone know if you can setup page filters on a beast mode field? Most of my datasets contain a company identifier that I convert to a string of the company name. Doing this as a beast mode is faster than running the datasets through a dataflow. The downside I am seeing is that the beast mode is not available as a page…
-
Convert_Timezone() function
This is an optimization issue I have run into when joining tables on dates. I am left joining a table of dates to the data to create a record for each date that a row is valid for based on the join criteria. This dataflow used to complete in 15-20 minutes when I was using convert_timezone('utc','est',c.start_date). DST…
-
Time Zones and DST
First of all I am bringing in my data through workbench and using the Shift Date Timezone Transform to convert my data from EST to UTC. Our company settings are setup for EST. All of my dataflows have been using the convert_tz() function on the datetime fields and everything was working until Daylight Savings Time began.…
-
Chart types not compatible with IOS app
Could someone point me in the direction of a list of unsupported chart types in the IOS app? It is frustrating to build out cards only to discover they do not work in the app. Thank you.
-
Subquery versus Output Table
I am always looking to optimize my dataflows and was curious if it was better to have multiple output tables in a dataflow or less output tables by utilizing subqueries? For debugging and readability it is nice to have multiple output tables but I do not want to do this if it will have a negative impact on performance.…
-
Order of Sub Pages
I would like all of my sub pages on a particular page to be in a specific order but this order is different for every user. I have them ordered correctly in Pages under Admin. How do I update each user so they view the sub pages in order?
-
Does RedShift offer better performance?
I am currently using MySQL data flows and indexing the join fields appropriately but performance seems underwhelming when dealing with millions of rows and/or GB sized data sets. Would I see a performance benefit utilizing RedShift? I began looking into the RedShift documentation and the first difference of note was…
