BlueRooster Domo Employee

If you go back through the parts of the transforms and click 'Run' for each of them, starting from the top down, do you still have this issue?

So if you're wanting to do comparison between objects over the same timescale (ie, YoY by month) I would personally use something like a grouped bar instead of stacked. I think it's a bit easier to tell if there is a difference between values. Here's how I would tackle it: 1.) Create a Monthname beastmode to return on the…

Yes, you'll need a SQL transform. Something like: SELECT * FROM table ORDER BY `Timestamp` LIMIT 1 That will give you the most recent row of data

So I think you would be be served by putting this into an ETL. I would break it into the following: (Grab Userids who've ordered greater than 12 months ago) Transform 1: SELECT DISTINCT `Userid` FROM OrdersTable WHERE `submitted_at` < DATE_SUB(curdate(), interval 12 month) (Grab Userids who've ordered in past 7 days)…

So if I understand you correctly, you're wanting to return the last "Non-zero" value found in each column based on the timestamp you have in a column. If I were going to tackle this one in my own environment, I would do it in a SQL transform. The pseudocode would look something like this: SELECT `Identifier`, (SELECT…

@user04417 great find! Best of luck 

At least as far as our instance, we seem to be running normally. Having AWS stats to monitor would be a great benefit though. Maybe that's one for the Idea Exchange? https://dojo.domo.com/t5/forums/postpage/board-id/Ideas Best of luck, ValiantSpur

@user04417 Yeah, I'm not seeing it listed there under funnel. I'm not even sure how that would look if you're showing a 0 value on a funnel If that's something that would be helpful for you, you can log it and detail what you want in the Ideas Exchange here: https://dojo.domo.com/t5/forums/postpage/board-id/Ideas If you…

Good deal @ST_-Superman-_, and thanks Hopefully we'll see this one implemented soon 

@user04417 To make a data label show when the value is zero, there is actually a checkbox further down in the Data Labels section. Check that box and the value should show: Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post…

Chad, The line for the 'Line + Nested Bar' will be whatever measure you put in the Y Axis field. Take a look at the screenshot below: The .Percent Change field will by my line in this example and the other two measures in the Series section are the resulting bars that make up your nested bar. So if you want something like…

Hi Adam, You can indeed have a mix of things like multiple bars and multiple lines on some chart types. For instance the 'Line + Grouped Bar' chart type by default will show multiple bars and a single line for your defined measures. To have additional lines displayed instead of the original one, you can go the General…

So this will be a two-parter. 1. To see what dataflows are using a specific dataset This is currently an idea 'Under Review' (https://dojo.domo.com/t5/Ideas-Exchange/Where-used-in-Datasets-to-show-Dataflows-that-are-using-Datasets/idi-p/12017) However, here's the work around... Currently the only way to do this is to use…

I agree with @Marc_H, it sounds like a data type mismatch. Are you joining use the ZIP or ZIP_STRING field from that dataset? Also, could you provide a couple of zip codes that it returned blank for? Maybe they were 9 digit hyphenated zip codes or had an odd character in the field? With more detail we should be able to…

To setup a publication group you need to the following: Open the Admin section In the Admin section select Publication Groups and then click "New Publication Group at the bottom" Start by naming your publication group In the first section you will define your page (which pages do you want to share). Note that pages listed…

If you're doing multiple percentiles like that, I would break them into concurrent data transforms that each run at the same time (where each transform only returns your ID field and the percentile being calculated). This way once they are all done, you start with your base dataset and then LEFT JOIN the other completed…

I'm not sure if you can do that via a Magic ETL, but I know you can with a SQL transform. It would just be a case statement like the following: SELECT *, CASE WHEN `2nd Item Number` LIKE '%LOT SQD STOCK%' OR `2nd Item Number` LIKE '%LOT SQD SPECIAL%' THEN 'SQD' ELSE `Supplier ID` END AS 'New Supplier ID' FROM table Hope…

One of the things we do that improves query performance is to try to make sure to add indexes on the tables we're querying in the transforms. Basic format is: ALTER TABLE tablename ADD INDEX (`columntoindex`) and uncheck Output Table. Here's a link where they're discussing indexing in more depth:…

The other option I can think of would be to create a dataflow that does that color analysis for you. You could do the following to your current table to add a 'Percentile' column: SELECT a.*, ROUND(100.0 * (SELECT COUNT(*) FROM test_table AS b WHERE b.`Values` <= a.`Values` ) / total.cnt, 1 ) AS percentile FROM test_table…

There are options to setup conditional formatting on a column (although it's not one click) This link should explain it well for you: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Setting_Color_Rules_for_a_Chart#Applying_Color_Rules_to_a_Table Let me know if…

So the problem is that the way you're wanting to display it (vertically with multiple metrics) there isn't a way to calculate all those metrics while including all the rows every time. The way to think about using BeastModes is that for every bucket your calculation is used in (Sales, Cost, Profit) the rows in the dataset…

So to do what you're looking for, you'll need to alter your source data a bit. You can do this in a data transform, but basically you'll need to seperate out your Metrics into a Cost column and Sales column and then just have the corresponding values below. So you would have the following:…

If your data is formatted as described, you should be good to go. I imported what you gave me and here's what I came up with quickly: The beast mode calculations I'm doing for Cost and Sales specifically are: CASE WHEN `Metrics` = 'Cost' THEN `Values` END (replace Cost with Sales for ther Sales Beastmode) Obviously, you…

We've recently recreated a P&L in Domo. I'll try to give a rough idea of how we did it. We're using a table card and have our columns set as follows: Line Type | Line Item | Calculation1 | Calculation2| Etc.. We're using the Subtotal Rows and Hide Counts options so that Line Types are displayed once, with each…

For getting your max value set to 100%, you can do two things: 1. Under Chart Properties, set Range 1 to Max Value of 1 2. For the Gauge Value field, select it and choose format -> Percentage Once you have those, you can start adding colors over different ranges using the other range values . Hope this helps get you…

When you're in the dataflow, if you click the wrench in the top right, you should have an option to "Cancel". This will stop the execution and allow you to change the version before rerunning. Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the…

After working with support it was confirmed that this was a feature that was removed with the last update. They also said that as they've had several requests to bring this back, they will be reintroducing this in a future update.

One option you have is to use the "Subtotal Row" field. Below is a screenshot where I believe I'm doing something similar to what you want: Let me know if you any questions or issues. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the…

A lot of this is going to stem from how exactly you're calculating the % Fail? For example if its # of processed rows of data / # of unprocessed rows of data then you could do Counts by Customer for each of those and divide them in a summation transform. Possible Example: Transform 1 - Count of Unprocessed Rows by Customer…

Hi, This was topic that was brought up a while back and had some really thorough explanations from Domo reps. Check out this link: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-can-I-add-only-unique-values-from-one-dataset-to-another/td-p/16549 They do a better job detailing it than I would. Hope this helps,…