MarkSnodgrass Coach

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.

I agree with @GrantSmith . Use the Group By tile and put name, account, date in the select columns. Then use the Max aggregate on the balance column.

@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.

That is the scatter card type under Data Science. You can build it by putting your state/region in the X-Axis. Use a day calculation in the Y-Axis, such as DATEDIFF(CURDATE(),'dt') . Put your measurement, such as total infections in the Bubble Size field. You can add the state/region in the series to make different colors.…

Unfortunately, you can't include HTML in that card type. It would be worth submitting it in the Ideas Exchange for a future enhancement, though.

The closest thing you can do is to choose Sync Value Scales under the General Chart Properties. This will make the left and right be the same. I would think it would make more sense to have your percentage field be the line and your two order counts be the bars in the series. You'd then be able to format the line as a…

@Ashleigh Workbench 5.1 introduced partition support which might be effective for your use case. You can read about it here: https://domohelp.domo.com/hc/en-us/articles/360062446514-Workbench-5-1-Partition-Support

@Ashleigh might know the answer to this one. She is a power user of Form Builder.

You could use a pivot table and put invoice payor type as a column and that would create a column for each. You could also use Magic ETL to pivot the data using the Uncollapse Columns tile. See this KB article: https://domohelp.domo.com/hc/en-us/articles/360043427353-Magic-ETL-Tiles-Edit-Columns#11. You could also create…