MarkSnodgrass Coach

It sounds like it could be a bug, in which case I would recommend opening a case with Domo Support. I would also try creating a new ETL from scratch and see if the issue persists.

@Jbrorby if you can avoid the recursive dataflow and make use of the append, that should prove to be a better long term solution for you as far as performance and maintenance. I would definitely recommend working through that option first and seeing if that works for you before going the recursive route.

Hat tip to @GrantSmith who wrote the articles, but I didn't initially call out because he is supposed to be on vacation and not on the Dojo. :)

A recursive dataflow is the most common solution to this. You can read about it in this KB article: https://domohelp.domo.com/hc/en-us/articles/360043428133-Creating-a-Recursive-Snapshot-SQL-DataFlow There are also KB articles for doing it in Magic ETL. I would also recommend looking at this YouTube video by @jaeW_at_Onyx…

I recommend formatting it to currency with the concat function in a beast mode. If you try and do it in an ETL, then they would become strings and the card wouldn't be able to sum them when a user is interacting with the card. Here is a beast mode that will format it for you and abbreviate the millions and thousands:…

@106004258 CSM = Customer Success Manager AE = Account Executive These would be employees at Domo assigned to your company's account.

That actually isn't specific to the shape card. I have noticed that applying a background color in a dashboard alters the size of other card types as well. I think it is worth submitting it as a bug to support@domo.com. A workaround might be to include a hexadecimal value of a value really close to white, so then those get…

The column widths will dynamically expand in order to fit your column title until it runs out of room due to the number of other columns and data you have in your card. A couple things you can do: You can use the column widths setting as you pointed out. This setting is expecting a comma separated list of values that total…

When evaluating a date, your date needs to be in single quotes. I would also suggest to have something in your outer case clause as @GrantSmith suggests. I'm guessing you would want to exclude those, so I have re-written it with that in mind. (case when `Date` > '2021-07-01' then (case when `company` like '%company1%' and…

The Dojo was very helpful to me when I first started. Now I use it to help out others and learn new and better ways to accomplish things.

@Anna Yardley may be able to group the threads together and get the various ideas consolidated. I agree it would be a nice feature enhancement

You could create a custom beast mode sort order to get the order you want. This, for example, would move Sunday to the end of the week: CASE WHEN DAYOFWEEK('dt') = 1 THEN 8 ELSE DAYOFWEEK('dt') END I would also suggest looking at this post for several other date functions that might be useful for you.…

You might want to look at using the Trellis properties for your chart. That provides a form of multiple x-axis functionality. https://domohelp.domo.com/hc/en-us/articles/360043429793-Properties-Available-for-Most-Charts#8.

Unfortunately, that card type doesn't allow for that type of drilling. Could be worth submitting it as an enhancement in the Ideas Exchange section of the Dojo, though.

I agree. It seems pretty redundant. The KB article doesn't give a good use case.

Reading the KB article: https://domohelp.domo.com/hc/en-us/articles/4404148803479-DataSet-Copy-Unload-Connector It sure seems like it is does the same as the dataset copy connector except that you are using a developer account and generating a client id and secret instead of an access token like you do with the copy…

As far as I know, the waterfall chart is not built to show three different variances. You could make a quick filter that would allow users to toggle to each variance. Or, build three different cards. Here's a link to the KB article for the waterfall card if you haven't looked through it already.…

Based on your example, if you are adding them all together, you would have a single beast mode that looked like this: SUM(1+1) + SUM(2+2) + SUM(3+3)

Glad my formula worked for you. You can only drill to one card. You can't drill to different card types based on what you click on if that is what you are trying to do. The field you click on will be part of your filter criteria.

@swagner I'm not seeing the option in my instance either on the Favorites page. I never used it previously on that page, but I see how you had it on your video. I would suggest asking your CSM to see if a feature was taken away at some point. Or opening up a support ticket and including your video so they see that it used…

You would need to combine your 3 beast modes into 1 beast mode. Have you tried doing that? For the filters, just add your business units and months into the filters section and turn on quick filters.

This should do it: CONCAT('<a href="https://www.helpdesksystem.com/usersui/ticket?ID=', `ID`, '" target="_blank">', `ID`, '</a>') This KB article may be helpful for you: https://domohelp.domo.com/hc/en-us/articles/360043430093

I would separate out the two calculations (this year, last year) and put include them in the card and see what those individual numbers look like. That will help identify where the problem is. I would start there.

When you use the date filter to only show the last 15 days, you are eliminating your data from the prior year, which is why your beast mode is not working as you would expect. You need to change your date filter to the last 12 months, at least. You can then create a beast mode to filter to the 15 day window you are looking…

You would need to repeat this for each column, though. Label the Beast Mode January, February, etc. and use the appropriate fields in each beast mode.

If Target is a field in your dataset, then you actually don't even need to worry about which row it is. This beast mode will color it based on if the number per month is greater than or less than the target. CASE WHEN `numberPerMonth` < `target` THEN concat('<div style="background-color:red; color:white; margin:-20px;…

This KB article also links to some helpful references: https://domohelp.domo.com/hc/en-us/articles/360043429993-Sample-Beast-Mode-Calculations

I edited my first comment to include a sample beast mode that would color the cells. If you provide some insight on your fields and rules, I can probably write one specific to your instance.

I would use the HTML table card so that you can construct beast modes that would color the cells based on your different formatting rules. Use the <div> tag to set colors. Here is an example syntax: CASE WHEN SUM(`Sales Amount`) < 300000 THEN concat('<div style="background-color:red; color:white; margin:-20px;…

Try just the following: ADDTIME('timeplaced','timeEstimate'*60) AddTIME expects the first parameter to actually be a datetime value, so no need for you to convert anything there. It expects the second parameter to be in seconds, which is why I am multiplying your minute number by 60.