MarkSnodgrass Coach

@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.

@GrantSmith is correct that you can't use Workbench for that purpose. There is a MS SQL Writeback Connector, though. Here's the KB Article: https://domohelp.domo.com/hc/en-us/articles/360043437013-Microsoft-SQL-Writeback-Connector Here's a screenshot of the connector if you go through Data Center and Connectors and search…

This would get you the starting quarter. You would follow similar logic to get the ending month. CASE WHEN MONTH(DATE_SUB(`dt`, interval 6 month)) < 4 THEN CONCAT('1/1/',YEAR(DATE_SUB(`dt`, interval 6 month))) WHEN MONTH(DATE_SUB(`dt`, interval 6 month)) < 7 THEN CONCAT('4/1/',YEAR(DATE_SUB(`dt`, interval 6 month))) WHEN…

You can utilize the LAG function to get the total from the previous month, like this: LAG(SUM(`value`)) OVER (ORDER BY `activitydate`) These window functions are not enabled by default. You will need to ask your CSM to "enable window functions in beast modes" in order to make use of this. Also, you can view this post and…

You might consider using the Dataset Copy connector. It copies a dataset between different Domo instances. This is nice because then you don't have to give anyone access to your instance. Your team can construct datasets that they want to share and then provide the dataset id to the engineering team in the other instance…

Unfortunately not. It is driven dynamically by what you select in the date range filter. It would be a nice enhancement as I find it confusing to read at times.

Did you try this? SUM(CASE WHEN LEFT(`Stage`, 1) != '7' THEN `Pipeline` END) OVER () / MIN(`AOP`) OVER(PARTITION BY `SF Selling Lane`)

I would not recommend replace text for this. I would create a lookup table with the country id's and the country name and join that to your main dataset in the ETL. You can use Domo Webform or upload an Excel file to create the list of the values. Add that file to your ETL and join on country id. This will be much easier…

This should do it: SELECT 'date', 'Name', 'Revenue' FROM 'estimated' WHERE 'date' > (SELECT MAX('date') FROM 'daily')

If you can re-create that percent change in a beast mode then you can drag that beast mode into the sorting properties.

You might consider appending rather than joining. Choose the Include All Columns option when appending so that you don't lose any columns and then you have a single dataset that you can build all your cards off of.