BCorless Domo Employee

You could potentially do that within a BeastMode, but that calculation would likely get pretty complex. If using the DDX brick, I would recommend the Phoenix Scatter Plots Brick

@Strongreece When I looked in the appstore at creating a new connection, it appears there are a number of connectors that were once available to pull data from Microsoft Exchange, but some of these have been deprecated (likely due to API endpoint changes or deprecations). I would suggest trying to set up a new connection…

@Jbryson Just to make sure we understand what the setup is, are you embedding this with the idea that users can input data into your app to update the data on the dashboard? Or are you attempting to allow users to input filter data to look at specific slices of your data?

While this is possible with BeastModes, having the ability to do this without creating a BeastMode would be super helpful.

Love this idea

Great suggestion

This is a great idea. I think it would also be helpful to show the state of the dataset (Draft, Disabled, Non-queryable, etc.)

@alfonsocastrof I looked up the available errors with TikTok's API and can't find that specific error. For reference, I was looking here: https://developers.tiktok.com/doc/tiktok-api-v2-error-handling/. I would suggest opening a support ticket to have this reviewed further.

This is a great idea, even more so if it's customizable for each instance to be specific to the company needs for their naming conventions.

@G_Grey There may be a way if you start concatenating a bunch of those values within a BeastMode, or by creating a custom app, but I love the idea of making this a chart type available in the base platform.

@user027926 While not exactly a folder, per se, there is an option to save favorite filters based on criteria set, including ownership, connector type, tags, etc. Would this work as an option for what you're trying to accomplish? The Knowledge Base article describing this option can be found here:…

@DomoFaye I would get a support case started with the specifics on this issue so this can be investigated further.

This would be great for all of Domo in general, but also the Buzz desktop application.

Hi DrGWright, I'm sorry to learn that dataflow is failing to successfully run. The first thing is to make sure you've optimized the dataflow using the tactics described in this Help Center article: https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows/Optimizing_an_SQL_DataFlow. The suggestions include Indexing…

@user08167 This looks like an issue where you'll need to work with Domo Support to resolve. We reached out to the support rep and they will follow up with you shortly. Thanks!

@Lukas Thanks for your question! The query parameters would be based on the type of SQL you are using from BigQuery. There is either a Legacy SQL (https://cloud.google.com/bigquery/docs/reference/legacy-sql) or Standard SQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql) which can be…

@daniel_frossard Other than the input/output sizes provided in the data flow history, we do not yet have a section that will provide you with the dataset size. Currently, the best sorting options we have are based on the row size, but not the total data size. I would recommend searching our Ideas exchange…

@noza_IMJ I looked into this and it does not appear there is an auto-refresh option for the Google Sheets add-on. Since this product is in the beta stages, I would recommend using the Feedback button from within your instance to let the product team know this is something you'd like to see with this. You can also search…

Hi @Brian Currently, REGEX is not supported within BeastMode. However, this would be great feedback for the product teams. Please search the Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. I searched that section and didn't find a suggestion yet created, but if your idea exists then you can vote it…

@user003279 I may be missing what you're trying to plot, but it sounds like a Gantt chart may work for what you want to visualize. This would give you a way of categorizing the series, and the chart will plot both the "start" and "end" dates of that series as a part of the project. Would that work for your needs?…

@AndrewMeier While I do not know of a way to dynamically change the color in the card settings, you could set up a BeastMode to dynamically review the values and set a color using HTML. That BeastMode is likely to get pretty long pretty quickly, however. I think this would be a good candidate to submit a suggestion in the…

Hi @user01258 I'm not able to login to see the dataset, but a common reason for datasets to be unable to be loaded into a MySQL dataflow is due to column name lengths. MySQL imposes a limit of 64 characters for column names. Does your input dataset have any columns longer than this?…

Hi @user06539 We have various apps in our App Store that give a pre-configured dashboard for Salesforce data. You can then add/delete cards to better suit the data story you are trying to tell. For best practices, we have a Help Center article that can help guide you in your card and page building to tell your data's…

@user07036 Thank you for your question! This is something that can be managed by using the Chart Properties within the card builder. Once you have added the x-axis, y-axis, and series as desired, you can then navigate to the Chart Properties menu, select "General," and then select the options presented under "Sort on…

@Wenling_Zhen Thank you for your questions! For your first question, this is something typically done during a consulting engagement in which reports from your ERP system are aggregated to match the aggregations being done in Domo to validate the numbers. This may require another technical resource, so we would recommend…

Hi @bvaut Within this connector, you are not currently able to specify what columns are importable/exportable from one instance to another. If you do not wish to import/export certain columns or rows into another instance, you would need to exclude that information by filtering the dataset within a dataflow. You would then…

@jman0527 We may need additional information for this question, but if this is in regards to showing a row and column total in a chart, this is possible within a Sumo card. I have included a screen shot of a sample dataset with a category and group and the totals for both columns and rows. Please let me know if this…

@swagner Another option is to do a nested CASE statement to account for the divide by zero in both divisors: CASE WHEN IFNULL(`Standard`,0) = 0 THEN 0 ELSE (CASE WHEN IFNULL(`Hours Active`,0) = 0 THEN 0 ELSE (IFNULL(Number of Lines,0) / IFNULL(Hours Active,0)) END) / IFNULL(`Standard`,0) END

@ST_-Superman-_ That is correct; the chart currently makes a query to your dataset, so the chart will only be able to render dates which are present within the dataset. However, this is a great idea to build that functionality into the card itself! Since we currently do not have such an offering, please visit the Dojo…

This will depend on your data. To make this work, we'll need the following components in the data: * At least one date in each month in the date column * A value for at least one day within the month So in this case, your data looks like it lacks any data for June 2017. A good way to fix this is by joining your dataset…