ColemenWilson Coach

You need to click "Properties" at the top of the window

The easiest, but perhaps not most efficient, way would be to utilize Domostats datasets, specifically the DataSets report. You can use the Last Run date time field and then a datediff/timediff and set logic in a beastmode that if the time difference between the current time and last updated date/time is beyond a certain…

If your dataset is less than 5MB you can attach a CSV as an attachment: You could also probably utilize workflows if the above option doesn't work for you.

I would try adjusting your Email Connector settings to the following, let me know if you still have an error after doing that. Additionally, if you change the file type to "Email body as HTML" you should be able to see the link and copy and paste it.

I would recommend the beast mode functions guide, although it is similar to what you get within the beast mode editor above . Beast modes are mysql, and you can get more detailed information by just googling the function name + "mysql". For example, "ABS() mysql." w3schools is a great resource as well:. Also asking…

I am seeing it in my instance. It may need a feature switch. I would reach out to your CSM!

Hi @benm_2000 could you provide more information?

CASE WHEN CHAR_LENGTH(`yourField`) = 7 THEN CONCAT('000',`yourField`) WHEN CHAR_LENGTH(`yourField`) = 8 THEN CONCAT('00',`yourField`) ELSE `yourField` END Note: this wont work in a beastmode, you'll have to use this in a formula tile in MagicETL

There is a form action/element you can add to the App Studio App: Have you tried this? Will this meet your need?

I don't know anything about Javascript but have you considered filtering the data through an ETL/Dataset View to current month data if that is all you need for the DDX brick?

For that I would look at Inline Editor: It is not as intuitive/easy to use as Domo's other products/features.

I am confused on how these are duplicates. Are they not separate transactions? For example, one online and one in store in the sample data above? If you want to see total value, why would you want to exclude customers?

Commenting in hopes this gets some attention!

There is an idea that @MichelleH posted last year to provide documentation on activity log events/actions. I would suggest others go upvote! This is a huge need for observability and something that should be a relatively easy lift for Domo. @BenSchein

I believe you need to recreate it. You could export the existing webform and then copy the data into a new webform. Or copy and paste directly from the existing webform into a new webform.

Okay are each of the lines you provided a separate field you want to use in a visualization? I was thinking it was all criteria for how you want to filter your data

This should get you what you need:

A calculated field something like the following: CASE WHEN `Policy status` = 'death claim' AND `Termination date` > `Effective Date` - INTERVAL 2 YEAR AND `Term` = 'sure' AND `RC4` IN('Express','Silver') AND `RC5` IN('Essence','Bronze') THEN 'In' ELSE 'Out' END To give you an exact beastmode I would need more specific…

So are there values in the cells above for those fields?

Double check that "Hide total" is not checked for those fields:

@emmanuelfabre_1 you're welcome! Next time you are in Utah let me know and I'll take you up on that!

I added the data for 2024 you provided above and the ETL I shared produces the correct lag_results values without nulls.

Yes I think this is a bug. We are having the same issue as well. I am going to open a support case with Domo and I can add this link so they see you are having the same issue!

Yes, you can use Dataset Alerts: Let me know if you get stuck setting it up!

My understanding is that you are looking for the final value with in a quarter to be the lagged value shown for each month of the following quarter. Wouldn't that mean the lag_result for 2023-05 and 2023-06 being NULL as well? Here is the solution I came up with:

Seems pretty straight forward. Domo is giving control over which accounts to retrieve. There are only two options: select which specified accounts you want or retrieve all accounts. It sounds like it may have caused some initial issues for you, but were they resolved? What are you trying to figure out?

The solution is to export the card, not the dashboard. When you export content as a PDF, Powerpoint, Scheduled Report, etc… it creates a static export that you cannot interact with as you can in Domo. For this reason, table cards that have over a certain number of rows will be cut off with no scrolling functionality. If…

The solution is to export the card, not the dashboard. When you export content as a PDF, Powerpoint, Scheduled Report, etc… it creates a static export that you cannot interact with as you can in Domo. For this reason, table cards that have over a certain number of rows will be cut off with no scrolling functionality. If…

Here's what I came up with on how to solve this:

I knew I'd be dethroned at some point but didn't think it would happen so quick! Nice work @david_cunningham !! Congratulations on the coach status!