ColemenWilson Coach

As shown in the error, there is a value '/3/31/24/' that is not in a date format or one that can be converted to a date. Either fix the value in the source data, or use a formula tile in Magic ETL to convert that value to '03/31/24' then use the alter columns tile to convert the string column to date.

It doesn't look like this is currently possible. I would suggest making this request in the

Hmm I am not seeing that for public embeds of App Studios Apps or Dashboards. Is this the type of embed you are doing:

Hmm I don't see that when I embed dashboards. Example: Can you share a screenshot of what you're seeing? Also how are you embedding and where?

So stoked to see the status change on this Idea!!!

In an ETL, isolate your quota data and filter so you only have 1 row per rep, per quota. Then join that back to all data on Rep = Rep. If you provide sample data with Rep, Quota, and sales amount fields I can build it in an ETL and show you.

So you want to compare the current quota, to historic sales data? If that is the case you can just join your quota by rep and then for every row of sales data the quota will join to it. You'd have something like this: Date Rep Sales Quota 1/1/2024 John 20 30 1/2/2024 John 25 30 1/3/2024 John 20 30 1/4/2024 John 23 30…

The quota field would remain, but previous quota values would be filtered out and you'd be left with the most recent quota amount.

LENGTH(Uppercase) - LENGTH(REGEXP_REPLACE(Uppercase, '[A-Z]', ''))

You can use 2 beastmodes: 1. This one will filter out anything that isn't Access Carrier. CASE WHEN `field` LIKE 'Access Carrier -%' THEN 'In' ELSE 'Out' END 2. This one will remove the text from the strings: REPLACE(`field`,'Access Carrier - ','')

Yes. In your ETL you can use a rank and window tile to assign a rank to the most current quota for each employee by date. It would look something like this: 1. 2. 3. Then in your card add a filter for the Rank Value field and set it to Rank Value = 1. This will keep the row of data with the most recent update date. Let me…

Yes. Would you mind sharing how your data is formatted? If you provide some sample data I can build the beastmode for you!

Huh. So as the input it is a date, but when using it in the ETL it is converting it to a text and not allowing you to convert it back to date? Seems like you have identified which date field is causing the issue, did you find the value '0/00/2024' in that column?

If you can change the type, the 2012-03-14 format is preferred. In Domo, navigate to the dataset and then inspect the schema. You'll be able to see the data type for each field. If you see a field that should be a date, but shows 'abc Text' Then that is likely where your issue is.

Where is your data coming from? If you can edit the value in the source system directly, you could change it from '0/00/2024' to a proper date. If that isn't an option, you could fix the data using a formula tile: CASE WHEN `DateField` = '0/00/2024' THEN '12/31/2024' ELSE `DateField` END

Are there other filters impacting the card? Could you share more to help troubleshoot?

Yes. You can do this using Color Rules:

Okay, were you able to get the count of candidates or do you need help with that as well?

To get that output, you don't need to use any beastmodes. You can just create a table card and aggregate (SUM) on TotalBilled

Count Distinct doesn't "remove" the duplicates, it just ensures they are only counted once. Is this the output you are looking for?

It doesn't seem that treemaps on a dashboard behave that way. I replicated a dual treemap setup with some data and the same thing happens - just the first value in the category will be highlighted. If you want, you could submit an idea in the . Although hover isn't behaving the way you are expecting, clicking + filtering…

COUNT DISTINCT is the right function. What do you mean it doesn't work? Could you share a bit more? If you want to remove duplicates in Magic ETL you can do so using the Remove Duplicates tile.

You can use the formula tile with the following formula: CONCAT('Division',`Division`)

Use a formula tile with the following formula: REPLACE(REPLACE(Column,'(','-'),')','')*1

What is the field used in the smart text? Is it a date field? I see, for example, that ship_date is not a date, but an integer or text.

Single-selection attributes are my preference for sure! But when I've had to deal with multi-select I use the split column tile and pivot/unpivot to get one row per selection and then use the data to build visualizations. Did you end up getting what you needed here?

Must be playing Zoom tag. I just rejoined again and I don't think you are still in the meeting.

You could use the group by tile. Choose what fields make a row unique and include them in the group by fields. Then do a count as the group by aggregation. Then join that back to your data. Anytime there is a value of 2 or more, you'll know you have duplicates. You could then use a formula with a case statement to add a…

Using a test user I verified that disabling the grant removes the icon! Thanks @MichelleH !

Sure thing. I am available today 11-12 MT or tomorrow 1-3:30 MT. Would either of those work for you?