Best Of

Re: What is up with the default drilldown chart?

Yeah, that is what all users see - the standard default drill path. Your options are to create a custom drill path (as you pointed out), disable drill paths, or keep the default. You could also submit improvements to the default drill view as an idea in the ideas exchange.

ColemenWilson

2

Re: Switching a Dataset to a Workbench

It could if you have beastmodes saved to the old dataset that are not in the cards/dashboards. But if they are saved on the cards and the fields stay the same, they should still work. Definitely test with 1 ETL before switching them all over!

ColemenWilson

1

Re: Filter in magic ETL

Yes - you can use the Rank and Window tile to create a rank based on your id. Then use the filter tile to return the rank you want. If you want the min id you can just sort ascending on your rank/window function and then filter to where rank=1. If you want the max id, you can sort descending and then filter to where rank=1. In your case, if you're wanting the min rank per group. You would need to partition by ID to start the rank over again for each id.

For example. Input dataset

The above is how you could set up your rank/window tile.

Example output

Filter to where rank = 1

This output matches your example requested result.

david_cunningham

2

Re: Filter in magic ETL

I think David's reply is correct if you don't have a rank field yet. If the rank field already exists, you instead would have to group by the id to find the max(rank), and inner join that back to the data, with the join fields being id = id and rank = max(rank).

Sean_Tully

3

Re: Additional Currency Symbols

@david_cunningham, yeah for sure! While I totally agree that we can find a workaround, it feels like a minor enhancement that would be pretty beneficial.

Caua_Soares

1

Re: Break out rows depending on columns having a value

You would use the pivot/unpivot tile in Magic ETL: https://domo-support.domo.com/s/article/360044951294?language=en_US There are examples in the KB article that walk through exactly what you are trying to do. Let me know if you get stuck!

ColemenWilson

3

Re: What is the problem with my beastmode?

@jasonm5545 I just commented on your other post that looked like the same question. Posting here as well so you have it.

The issue is the argument BETWEEN. Try this instead.

CASE   
  WHEN Donors >= Lower Budget Threshold OR Donors < Upper Budget Threshold  
    THEN 'Normal'  
  ELSE 'Outlier'
END

david_cunningham

1

Re: Filter a table with aggregated rows on a dashboard with a filter card

Sadly (or at least AFAIK), while the icon for the Slider control icon depicts two dots, which would make you think you can select a range with it, this is not currently the case and you need to create a different variable for the lower and higher end of the range individually. Perhaps something worth sharing in Ideas Exchange.

marcel_luthi

1

Re: How can I limit the data based on user?

You can use PDP for this. Set person1 to only see their data, and person2 theirs.

Here are more details on how to configure.

https://domo-support.domo.com/s/article/360042934614?language=en_US

david_cunningham

1

Re: CSV separator but not

I think if I'm understanding your problem, I would use SUBSTRING to split your string based on position and characters.

Based on your example:

If the columns are variable in length, and there is no pattern or delimiter, I'm not sure there's a great solution even using regex as you need a pattern to be able to match with regex.

JasonAltenburg

1