dthierjung Contributor

Fusion is fantastic for relatively simple joins on large datasets that number in the tens of millions of rows and greater. The ETL and MySQL dataflows are different ways to accomplish the same end goal, allowing the user to pick the method they are most comfortable with. Some users work best in SQL, so the MySQL ETL…

"WHEN (`Planned Hours`-`Total Hours from SOW Breakdown`)/`Planned Hours`.0" is the issue. Change that to: WHEN (`Planned Hours`-`Total Hours from SOW Breakdown`)/`Planned Hours` > .0 Notice that added ">" towards the end.

Without the exact error you're receiving, it's tough to troubleshoot this. I'm guessing a syntax error though. My first guess would be your equality statements where you say ">10%" for example. You'll need to convert that to a decimal like ">.1", and so for the others. Try that and let us know how it works.

They support this to a certain extent with the Annotation feature. Check the attached images for screenshots of how to do that and what it looks like.

Oh no no, just user's who log in to the same server will have access to the jobs stored there. I might have misunderstood yor original question. For example, a workbench on a local computer would not be able to see any of the jobs on the server workbench, and vice-versa. You can export a job as a json file to import into…

It's definitely possible. The best route probably is to reach out to your sales rep and have them confirm the details of what Domo's RedShift is capable of.

If you have a Workbench on a shared server, all users would have access to all jobs. You'll want to be very careful with this approach though, as multiple open workbench instances can lead to unexpected results. For instance, if 2 workbenches are open and one user makes a change to a job, then two different versions of the…

I believe that you have to have RedShift enabled on your Domo instance by your sales rep, as it is not enabled by default. And I believe you need to have a use-case for it as well since it sounds like it costs Domo money to enable it. Do you know if it's enabled for you?

Are you using the One Drive connectors available in the Domo App Store? There is a regular connector as well as one for One Drive for Businesses. See attached for a reference to find those two connectors.

Unfortunately the chart properties cannot be tied to a beast mode or data column (great idea for the Ideas Exchange forum). I'm not familair with your data strcuture but you can get creative with the gauge chart for example, and calculate the target value so it adjusts accordingly.

As far as I know, variables are not supported in Domo's MySQL dataflow. As a possible solution though....you could have one transform output a table that just has the value you are trying to store, and the access that table in another transform. That might not work as effectively as I see it in my head, as it depends a bit…

I know that Domo should support all MySQL functions, but it looks like it doesn't like the between operator. You can try using the equivalent statement though: (CASE when `type`='PICKUP' AND `pickup_date` >= `appt_start_time` AND `pickup_date` <= `appt_end_time` then 1 END)

You can create a BeastMode function which returns the count of distinct (unique) values for a given column like so: COUNT(DISTINCT `AccountId`) Let us know if that helps you.

As far as I know, MySQL doesn't allow for data to be cast as XML, or at least it isn't one of it's supported cast to data types. However, there are a couple MySQL XML functions you can leverage. Check out this page: https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html They have some pretty good examples which should…

We might need more info to help you. * Are you using the new Dashboard feature (currently in Beta so you would have had to specifically ask for that to be enabled)? See attached as a reference for what this dashboard option would look like. * Are there any page filters on the page and/or applied? Or quick filters…

You can also open an issue on their pydomo github page posing the question which might actually gain more traction from the developers who maintain the package: https://github.com/domoinc/domo-python-sdk/issues

It seems silly, but yes there isn't a default option in a table card to abbreviate values, like you can in other card types. Like you mentioned, you'd have to build a beast mode.

In order to join two tables horizontally, there needs to be at least one column in common on both to achieve the join you are looking for, so you'd need to add that to each table. After that's, it's a simple join. E.g. add a column to both tables with the value of "1", and then join on that new column. Can provide a more…

You can potentially leverage the column filter options as listed at the top of this page, but it doesn't explicitly state the number of rows that you can retrieve: https://developer.domo.com/docs/dataset-api-reference/dataset#Export%20data%20from%20DataSet I don't think they offer the capability to limit the row return…

There are several ways you can accomplish this, however there aren't any native Domo methods that would help on this. Domo is a great tool, but accepting user input isn't necessarily one of those use-cases at this time. As far as what Domo supports, the most straight-forward approach could be a shared Excel sheet which…

@ST_-Superman-_ I was actually on the post admiring your PhotoShop skills (Black Belt well deserved just for that detail), so I only stumbled upon the response incidentally lol.

Oh, would you please check that when you clicked the "Add Transform" button, you have selected the "Table" and not "Transform" option? See attached for a reference.

I think the likely solution is that on the card itself, you need to specify the date range to include the previous 2 years, like pictured in the attached. Let me know if that helps.

I'm not 100% sure how to go about it given the data structure. Take a look at this link which goes into depth about grouped and stacked bar charts. They have some pretty good insights actually. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Grouped_and_Stacked_Bar_Graph From…

I think the below screenshot is what you were looking for?

Ok thanks. And what kind of database are you trying to query? At first glance, this looks like a PostgreSQL error, and specifically something structural with the table itself. Can you query the table successfully in a local query environment? 

Are you querying a SQL table or a SQL view?

Okay that helps clear it up. What datatype is your column "campaign_schedule_date_local" stored as? DateTime? The way we tackle Period Over Period calculations is like this: * Set the date range to the previous two periods (days in our case). * You'll need 2 calculations: 1 for the current period (day), and one for the…

So I'm a little confused after reading your question. You want to calculate day over day changes for campaign activities. You have records from previous days but these are skewing your numbers? When a user views the card, you want them to see the current day's (up until 23:59:59) campaign numbers compared to the entire…

I'd need to dig up my old python Domo app but in the meantime, can you verify that all your data that you want to upload adheres to these specifications? https://developer.domo.com/docs/dataset/formatting-data-to-import