GrantSmith Coach

You'll want to both kill the Workbench process and restart the Workbench service in services to make sure it's no longer running and attempting to process your data. If that won't work then there's always the Windows solution - reboot the server.

Or even simpler you could try and check the General > Reverse Color Direction option in the settings.

Try using a beast mode to multiply your value by -1 to flip the ordering and thus the color scheme. You can then also use the tooltip 1 for the actual value and display that in the tool tip / data value properties.

Can you post a screenshot of your code and the error your getting?

Hi @your_super_shawn , I'd recommend reaching out to the App Support team at domoappsupport@domo.com. They will be able to help resolve your issue. You can follow under How to Submit a Bug to help get an answer faster.

CASE WHEN COUNT(CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') THEN `ChildPlusID` END) = COUNT( CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') AND `Event Status Code` = 'Completed' AND DATEDIFF(`Event Date`, `OriginalEnrollmentDate`) <= 45 THEN `ChildPlusID` END) THEN 'Completed' END This is assuming…

Start with a day and see if that's returning all of your data.

Hi @shrikantdeshmane Is it a matter that it's throwing an error message or it's saying it succeeds but just doesn't update any records? What was the code you used to create the table xxtm_demand?

@gbrown Glad to hear it! If you could accept any answers that helped solved your problem so others can easily find the answers I'd appreciate it!

You can use a Rank & Window tile with a MAX aggregation to get the most recent date. You can partition by the project_number to get the latest date for each project.

You can replace the FLOOR(SUM(`random_number`)) on line 11 in the example with the beast mode that will format the value with commas. You can refer to the Number Formatting link I sent earlier.

@tlammie1806 Google restricts the amount of data it will pull in the APIs due to performance reasons. If you limit your request to a small enough dataset it will return everything, otherwise GA will return a sample of your data. You may need to pull data for a specific day to reduce the size and have GA return the entirety…

It's not possible to include an average when using a category series. You could create a separate graph to display the overall average next to your original graph.

Are you grouping by anything? Have you selected to graph by day or month in your date selector (upper right of the graph)? What type of graph are you using?

Here are a few posts on beast modes that may help you:

Agree with @MarkSnodgrass. To clarify you'd need to do this within a Magic ETL dataflow as a beast mode on a card won't support the multiple aggregations that would be needed.

Glad it's working again for you.

I tested this in another instance and it seemed to be working. What specifically is the issue / how is it not working? Have you made any changes to your configurations recently?

@nshively - Is this the first record for the effective date for the job title? If so, lag can't get anything before it so it will return a null. Also - just to confirm is your beast mode using back ticks (`) instead of single quotes as displayed in your formula above? I'm assuming so and it's just a formatting issue with…

How did you do the appending? Did you do a left join from your all records to your duplicate remove records dataset based on the primary identifiers between the two tables? If the identifier isn't found in the removed records dataset then you can use a formula tile to calculate it's a duplicate CASE WHEN `id field from…

You can select the type of aggregation for a pivot table or table with subtotals under the Subtotal options for each column you include and toggle whether to show the subtotal or not.

Sorry, I had the wrong format, try %m-%Y.

Are you currently logged into your instance? If not try and log into your instance again in another tab and then try and save it again.

You can use a formula tile and the STR_TO_DATE function STR_TO_DATE(`Month`, '%Y-%m') Alternatively you could just use LAST_DAY to get the last day of a month to get the month of your date / timestamp field. LAST_DAY(`RRDAT`)

Currently this isn't an option with how Domo works. You'd need to either use a contains filter and have the user type in the filter value instead of a selection filter or have one record per person and subject.

More auto-formatting issues. Try this version for your procedure definition. /*Dynamic Reverse Pivot*/ CREATE PROCEDURE Pivot() BEGIN SET @cols = (SELECT GROUP_CONCAT(DISTINCT CONCAT('MAX(IF(p.`Target` = ''', `Target`, ''', p.`Target Value`, NULL)) AS ', `Target`) ) AS Base FROM `preformat`); SET @sql = (SELECT…

Looks like my copy and paste was bitten by the forum formatting. Remove the first line and it should work. /Dynamic Reverse Pivot/ Alternatively you can change it to what it should be /*Dynamic Reverse Pivot*/ the /*…*/ just represents a commend to add some contextual information but doesn't do anything to the actual code.

Have you looked at the domo.filterContainer() method?

Microsoft does have a Planner API ( You might be able to write a custom connector to pull in the planner data instead of having to write it to a SQL database and then import into Domo.

There isn't anything out of the box that would potentially allow you to replicate this specific visualization. You might be able to do it with a Domo Brick but that's a more technical route.