cwolman Contributor

I work around this issue by selecting my data in chunks and running the job multiple times until all of the data has been uploaded. You will either need to do this by dates or a unique record identifier and replacement variables. Depepnding on the number of columns and size of the data in the rows will determine how many…

I do not see an option for rounding in a magic ETL but you can use the round() function in a MySQL dataflow. An example of how to use the function is below. You can copy and paste this into a transform in a MySQL ETL to see how it works. You would replace the 25.751 value with the column name that you want to round. select…

Looks like @Valiant already had this suggestion posted! https://dojo.domo.com/t5/Ideas-Exchange/Default-Selection-for-Filter-Cards/idi-p/38996

The majority of the time is loading the rows into the ETL and back into Domo when complete and indexing. This process needs to happen each time you run an ETL. I do not know what transforms you need to perform on the data or your data source. Depending on each may give you some options. If you are using workbench then…

I think there is some confusion on what I am asking. I am talking about the new Date Selector Filter type chart which is used with Domo Stories as an interactive page filter for the dashboard. I would like this calendar to have a default date so all of the cards on the page are not defaulted to the current year. Thank you…

Any default range would be acceptable. I have not been able to find a way to set a default value on the Date Selector card.

While editing the dashboard you can turn the card summary and titles on or off. This is accomplished by clicking edit dashboard. * Mouse over the card and click edit content. * Click Display Settings. * Click on Summary to toggle on/off the Summary Number. You will also see the option to turn on the Title as well.

Thank you! That is fantastic and drove me crazy for the past couple of days trying to figure out how I did that.

I figured out how to make the Presets available. The title must be displayed on the card in order for the hyperlink to display under the wrench menu.

This is awesome! It started me down the right path and I was able to create the svg with inkscape without using the online converter which gave me clearer images. The card works great on the computer for filtering but does not appear to work on the mobile app. Did I do something wrong or is this not an option for mobile?…

You can find this info in the Domo Governance Datasets. This is available in the app store via a connector. Do a search for Domo Governance Datasets and you should find it.

I am not aware of a limit on rows. Yes you can have datasets with more than 50M rows.

Could you share your sql?

It is hard to see but it appears that all of your transforms are outputting 0 rows. Do you expect 0 rows?

Typically the calendar table will not change. If I understand you correctly this is why the dataflow does not fire. Domo will not run at the scheduled time because the calendar table has not changed even though my output would be different. Maybe I will create a workbench job that runs daily at 6am that outputs the current…

I have seen the same problem and could not make it work in beast mode. I think the only way it would work is if we could pass the current date range selected on the card to the beast mode as a parameter. I have created dataflows that join the dataset back to itself and create columns for the current year and previous year.…

Thank you. Thinking about the magic etl flow differently than typical sql had me turned around a bit. My list of exclusion account numbers are available from another dataset but I was stuck on the not in syntax and did not think about outer joining and filtering the nulls. Thanks again. 

I had a problem where the next hyperlinks were displayed off screen and I could not remove the feature boxes. I put my browser into full screen mode and then was able to click through the screens.

How do you append data to the historical dataset quickly? It usually takes a couple hours to load the historical data, a few minutes to append, and then another couple hours to create and index the historical output. In my case it takes around 3-4 hours to append 25k records to a 20M historical dataset. Unfortunately this…

That looks great! I wonder when our instance will have that feature?

Thanks for the info. I have no idea what is involved with creating SVG files so it will probably move fairly far down the to-do list for whenever (if) I can get caught up on current projects. ?

I started looking at utilizing the magic etl option and realized that it cannot do complex joins so this will prevent me from using magic etl. Our POS data has start and end dates and I need to create rows for each day in between depending on the specifics of other columns in the row. It does not appear that magic etl can…

If you are using Workbench then you can setup custom schedule groups and set intervals however you would like. https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_4/10Creating_a_Schedule_Group_in_Workbench_4 You could setup a file watch job in workbench and have a file update everytime a record changes…

1. If magic ETL offers a performance boost then I guess I will need to start dragging tiles around. It always seemed simpler to me to type the sql. The Domo Period Over Period cards do not allow custom summary numbers and you are limited to using a date field and only 1 metric. There are other formatting limitations but…

1. Both mysql and redshift exhibit these fluctuations in run times. 2. We have separate datasets and dataflows for different metrics that need to be calculated totally differently. 3. The aggregrations are an attempt to roll up the data for faster performing dataflows. I am curious if it would be better to do the…

I have run into this issue in mySQL dataflows and my workaround was to run the table through an ETL dataflow first as that does not appear to have a column limit. The ETL would exclude any extra columns not required.

You cannot change column names in a beast mode. Column names would need to be changed in a dataflow.

Assuming you have the timestamp in your data you can put it in the summary number through use of the concat() function in a beast mode. Screenshot above. One thing to note is that you lose all formatting using the concat() function so you will see additional functions to format the numeric value with a comma. Beastmode…

Are you opening the csv file in excel? Excel drops the leading zeros. Open the file in notepad or another text editor and you should see the leading zeros in your csv file.