GrantSmith Coach

Currently the data table will only display the data that's displayed on the graph. There isn't a way to have it included in the included table without displaying it on the graph. You could have a separate chart for just the graph and include the data you wish there on the page. Alternatively you can suggest this through…

You can use a formula tile to populate a new user id column in your old dataset by just appending the @email.com with a CONCAT formula: CONCAT(`Old User Name`, '@email.com') Then you can use that new field to join to your new dataset and get similar records.

Good clarification @MichelleH @jtrollinger it should end up with something like this CASE WHEN `HdrParentItemCode` IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN' WHEN `HdrParentItemCode` IN ('ZTOPOUT', 'ZGAS') THEN 'Topout' WHEN `HdrParentItemCode` IN ('ZTRIM','ZDROPIN') THEN 'Trim'…

Alternatively you could filter the rows for non null values, feed that into a remove duplicates based on your two ids and the use a join tile to join them back together based on the id fields and then rename the new category

If the category is the same across for each store and ticket I’d you can use a rank and window tile to get the max value of the category for a new column and then use an alter column tile to drop the old category field and rename your new category field

@Aag2023 there aren’t individual edit permissions currently within Domo for dataflows. Permissions are based on the input datasets. I’d recommend adding an idea to the idea exchange for added dataflow security

Only the first CASE keyword is needed you can remove the others but leave them when and clauses

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 https://developer.domo.com/portal/e3bddcb552199-troubleshooting#undefined 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: https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting https://community-forums.domo.com/main/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number…

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.