n8isjack-ret Domo Employee

You can turn the basic schedule off in that case. It does not need to be enabled for the schedule groups to work.

Hi @AS, there are no active plans on the roadmap for this. Love the idea though.

Hi @TerryL, a user must have full access to all input datasets in order to have access to a dataflow. Access to the output datasets does not have any bearing on access to the dataflow. Access to the dataflow will be automatically granted if the user has full access to all the inputs. If PDP is applied to a dataset and the…

@RamneetKohli many companies do this using their browsers or other screen casting technologies. We have also provided the Domo Apple TV App for this purpose. 

Hi @RamneetKohli, you can use Windows Task Scheduler to do this type of schedule. See "Creating a Schedule Group in Workbench 4" for more information.

Hi @TerryL, there is not a way to block other users. We are working on adding this capability in the recently announced Bestmode Manager tools but we do not have a date for their availability. You can see when changes are made to beastmodes in the Activity Log. This will also identify who made the change.

@cwolman, yes that is a great use case for it. Key things to note: * There must be no overlap between Dataset A and Dataset B. You cannot update records that already loaded into Dataset A using this new method. * Correcting errors is trickier. If a data load must be reloaded or was loaded twice it is difficult to correct…

Hi @SaiKumar I think this is an excellent suggestion. I would recommend searching our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea exists then vote it up, otherwise submit your idea so others can vote it up. Feel free to post the link to the ideas exchange article back in this…

Hi @SamCam I am not familiar with that particular error. You may want to install the latest version of the plugin if you haven't already. Otherwise please work with our support team via https://support.domo.com to have them review the cause. This plugin is still in beta and they can help have it looked at.

Hi @cwolman, this is a pretty exciting change but it is for specific situations. It likely will not replace your recursive dataflow. It will allow you to take data that can simply be appended, but modify it first. Say that you are loading sales transactions. Dealing with hundreds of millions of rows is slow but you can…

It is best to 'replace' the data from workbench. This way the recursive dataflow will only be fed the records that workbench sent today. In Addition: One idea I would point out is "Intentional Overlap." I just made that term up, but I like it. When you are setting up Workbench to pull only the 'new' or 'recently updated'…

I see. That makes sense. Let me clarify though, so in your example you would have the image of a cup that starts empty. As the metric number (ie: donations, sales, sessions, etc...) increases, the cup will fill up and will reach 'full' at some target number? This is creative. I wish we had a chart type that would do that…

@SaiKumar this is a great request. Just to point out that when connecting to the data you have the ability to specify the delimiter for the file parsing. In your case the data is "sub-delimited" inside one of those columns. This can be parsed in SQL but is not a simple process. Will you submit this idea to the Ideas…

Hi @mfaas, the legend can be hidden entirely, but individual parts of the legend cannot be removed. To remove it entirely you will use the "Legend" properties and set the 'position' values for landscape and portrait to 'Hide'. Color rules can be applied 'always' by leaving the Condition blank. Notice that if the condition…

Hi @user01593, unfortunately we don't have other iterations of that script ready-made. It would have to be built out custom. Just for reference there are tips and tricks in the adwords article. One such trick is to use the "BigQuery Data Transfer Service" to extract data and then connect to BigQuery from Domo. More…

HI @Hulachic5, you will want to use a recursive dataflow to depulicate the data. This is different than using an append. We have some guidance for SQL and Magic ETL to help you with the framework. Basically you will load the new data into a dataset that is set to "Replace" itself. That data feeds into a dataflow that will…

Hi @user01325, others have worked through how to hack an image from a document card. It works with some success but as it is not officially supported any changes to the Domo product may break those links. It is a better practice to have those images available through other means such as hosting them on your company server…

@nlonkai you can also do window functions in Magic ETL as well. There is an article in the knowledge base that goes over the steps: https://knowledge.domo.com/?cid=etlactionsrankandwindow

Hi @AustinB97 thanks for the screenshot. You won't be able to get a decimal place in that guage. Thank you for the suggestion which is a great idea! Please visit the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what…

Hi, that is not possible in the "grid lines" functionality. You now have the ability to set line or range scale markers dynamically based on a percentile, percentage, or standard deviation. Median being the 50th percentile you can get median lines by themselves. There is more information in this article. Look in the "Chart…

Ah, that helps me understand a lot better what you're chasing. Thank you for the screenshots and detail. The null values are considered to be the end of the list. In the case of a "Descending" sort that brings them to the top, even before your largest value. You can correct this either in the underlying data, or a beast…

Ok, help me understand the impact of the load order. My first thought is that the order in which they are loaded will not affect the end result in Domo. Is it because you don't want to load the old files ever again once reloaded? Are you loading all files every time? Does the same record appear in multiple files?

@Sweep_The_Leg there is a way, using Yahoo finance, to get stock information into Domo. It is very flexible and can provide a LOT of good information. NOTE: This is not a basic process. An understanding of web url manipulation will help. You may need to study the Yahoo API documentation as well. I will do my best to…

Hi @jaz, There are tight measures on custom apps to ensure that they are sandboxed into their iframe. It gives you free reign to have custom code but keeps code tightly packaged. You can get this reviewed by submitting a ticked to support@domo.com. They can have our product teams review the possibility of allowing that…

Can you confirm that you are using a .csv file import?? This trick only is possible with .csv files.

Thanks for offering to load a sample file, normally that would be useful. I was able to recreate what you are seeing though and you are correct, it is unrelated to the risks already outlined in this thread. It appears that the # character, when it is the very first character on the row, is being treated as a "comment"…

There could be a few things that will cause that to happen. If the field is a numeric or date field for example, the hash tag is not a valid character and it will cause an error. These types of errors can be handled in a few ways using the Settings in your workbench dataset job: From your description of what is happening…

In Domo each transform can only run a single command. You have, by my count, 5 commands trying to run and it will throw an error. So here is your script, but I've marked each line that Domo will consider to be an individual command: * drop procedure if exists load_foo_test_data; * delimiter $$ * create procedure…

@iresanjogar In workbench you may be able to load all 15 files in a single workbench job. The base requirements are: * All the files must have the same schema (column 1 on all 15 files must be the same data type, column 2 also, and so forth for all columns). Workbench will assume column positions match, not column names. *…

Formulas in general work great, I just tested it out again to be sure and the values come across clean. In the Google article mentioned above (https://support.google.com/docs/answer/3093281) it states: * Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you will…