ColemenWilson Coach

Fixed functions only work in beast modes. To do this in ETL you will need to add a constant if one doesn't already exist, this will be needed for a Group By to sum up Amount. This step replicates the first part of the fixed function by getting you a total amount for sales for your grouping. The next step is to join the…

I am assuming you also have dates? Do you have a date time? Some way to order the events taking place? If so you could use a lag function and look for the procedure that occurred prior to the Upgraded Procedure.

I've set something like this up. I append the data everytime it updates instead of replacing it. I then do a lag function to see what the previous value was and compare the two. If they don't match it triggers an alert.

Congratulations @Data_Devon! @everyone please upvote The Text Card idea!

We were able to meet a few weeks ago and get this figured out!

There is a Domo Dimensions Connector dataset called countries_latitude_longitude.csv but I'm not sure the best way to accurately join this data. You'd need to maybe round the data so it would join cleaner (maybe to the tenth?) but I worry about errors. The better option would be to use DomoGPT in a Jupyter Workspace model…

Take a look at your grant settings for forms. Ensure that Manage Forms and Create Forms are enabled for non-admin users. Hmm, I tested it and you actually don't need either of those grants to use forms in App Studio Apps. I would submit a support case to Domo and let us know what they come back with.

Dynamic ranking is possible, but like you said would show a rank of 1 when PDP is applied. You could use Column Level PDP to hide sensitive data about other vendors. I think Column Level PDP is still in Beta but you could reach out to your CSM to see if you could try it out. I like doing ranks in an ETL. Is there a way you…

There isn't, but you could reduce the available data on the pivot table card using filters or pre-aggregate the data in an ETL.

No. If you want to do it on the card level you need to use the CONCAT() method in a beast mode.

You'll want to keep those checked. The other thing to check is to: 1. Edit the dashboard 2. Hover over the first filter card and click Edit Content 3. Click "Change Interaction" 4. Ensure that Enable interaction filters is checked and that apply to all cards is selected

Navigate to the dataset > Click "HISTORY" > Scroll to the update you want to revert to > Hover or the right side of that row > Click the wrench icon > Click "Revert to this point"

You said you had a field with tags. Add that as a filter in the "Filters" section of card analyzer view (the view where you are editing the card). Then filter by Selection on the Tag field and choose the tag that is current.

Agreed with @Data_Devon ! Period over period chart types are the way to go

There is no one-click way to duplicate a dataset. You'll have to just create a new dataset that is a duplicate of the original.

It shouldn't but to be safe you could create a duplicate dataset first

You could append your data in an ETL so it is formatted like this: Then use Value as a filter. Another option, use CONCAT() to bring the values of all 3 columns into a single column and then use the "Match Values" filter. The CONCAT() beast mode would be: CONCAT(`Buyer`,', ',`Seller`,', ',`Lender`) So you'd have a column…

You can revert to a previous update or update the data in the source system and do a replace update.

Yes. In the dataset click "Settings" and then "Details" and then in the Date Range section choose "Append Data"

You would need to use a DDX brick and custom map chart. Alternatively you could use a specific color (perhaps a company logo color) for the dot.

Interesting, it only seems to fill in when looking at a previous time period for the YoY comparison. When I use current year vs previous year it doesn't fill in.

Awesome! And you can of course switch it to graph by day, week, whatever to fit your needs. Glad I could help!

This doesn't answer your question, but a suggestion, since I built this card yesterday and have it on my mind, is to use the running total chart and add a YoY comparison and then show the data table under the running total line chart. This wouldn't require any beast modes and I think is a helpful visual.

Looks like there was a minor incident reported where some were experiencing connectivity issues within the datacenter.:

It is because there are days in 2025 (January 1, 2, 3, 4) that are part of the week starting December 29th. So for the week to start with Jan 1 would be an incomplete week and would not be consistent with the weeks to follow on the graph. You could format your data in an ETL to be grouped by a custom calendar week start…

Yep! On the dashboard with the text box, select a card (open it in details view) before or after the text box. Then, toggle over to the card using the arrows as shown in the image below: From there you will be able to save-as the text box (Notebook card).

Could you share screenshots of your ETL? The pivot tile details.

Yes! If they are from the same datasource this will happen automatically. You may need to adjust filter exceptions if they have been applied previously.

First click "Edit Dashboard" and then use the wrench icon on the card once you are in dashboard editing mode.

Do you mean that you can not drill down at all? Or that once you drill down the data is wrong? Check the card interactions and make sure Drill in place is selected. If you have not created a drill path for the card then the option to select "Drill in place" will be greyed out and you will not be able to select it until you…