Best Of
Re: How do detag a column
@MarkSnodgrass I am seeing the same in my instance as @NathanDorsch
Re: How do detag a column
@MarkSnodgrass @NathanDorsch I am an admin in my instance. I can click the 3 dots on datasets/dataflows but not on dataset fields.
Re: How do detag a column
so I checked another dataset I exclusively own and sure enough, I was able to do what you suggested, @MarkSnodgrass So, maybe the fact that multiple people own this dataset is preventing me from editing the tags... which is just odd.
Re: How do detag a column
@NathanDorsch Can you send a screenshot of what you see when you click on the tag?
Re: Quick way to determine number of unique values per column
@NathanDorsch Yes, if you want to know the number of unique values in each field then you will need a distinct count.
Re: Are Rank functions case-insensitive?
@AndreiA Is there a pattern of when a character would be uppercase vs lowercase in your id field? If so, you could create a secondary concatenated id to use for ranking. For example, if the last character is uppercase for Product A and lowercase for Product B you could use a formula like this to create your new partition id:
case when `Product` = 'A' then concat(`id`,'A') when `Product` = 'B' then concat(`id`,'B') end
Re: Quick way to determine number of unique values per column
@NathanDorsch You could use a PivotTable card to export, but you would still have to create a count(distinct) beast mode for all 400 fields.
Re: Quick way to determine number of unique values per column
@NathanDorsch You can see some high-level statistics for each column in the Data tab of your dataset by toggling the statistics icon to the left of the column headers
Re: Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?
@maodag What connector are you using to create your Federated Datasets? Some connectors allow you to write SQL queries directly in the request. You could also use MySQL dataflows, though that requires having a dataset created for each input table.
Here is a KB article that outlines all of the available data processing tools and when to use them: https://domo-support.domo.com/s/article/360042935434?language=en_US#3.4.