-
Re: How can I get rid of extra characters in attributes
If it is always between the first and second underscore, you can do this: SPLIT_PART(fieldname,'_',2)3 -
Re: Remove 'by month' from Card Summary
You can remove the by Month by editing the dashboard and click on Edit Content on the card and choose Appearance and uncheck Timeframe.1 -
Re: How to combine multiple values for one item separated by a coma
You can do this in Magic ETL with the group by tile and using the group_concat function. Results in this:1 -
Re: Can I filter by latest date?
You are going to need more than just the filter tile to do this. Here is bare minimum of what it would look like: Add a Constants Tile that you will use for the join tile Add a Group By Tile that get…1 -
Re: Order By
@ArborRose you can actually set the order of the output dataset without modifying the ETL and adding a select columns tile. In the Data Center, click on your dataset and then click on Data and then t…1

