How do I get unique values from a column?

Zel · 2023-05-11T21:18:26+00:00

There was an error rendering this rich post.

Hi all. I need help in getting the unique values from a certain column. See example below

Say I have this column below with multiple duplicate names in it, I only need to show one for each name. Please help. If it's possible through beastmode, it would be better, because I'm also utilizing slicer/filter for this card, so I have to use same dataset. Thank you

Find more posts tagged with

Accepted answers

MichelleH

@Zel In that case you can keep using a grouped bar chart with Tech Name on the X axis and Normalized Store Chain in the series. If you are still encountering duplicates, then be sure to remove any sort fields in the card.

All comments

MarkSnodgrass

If you are in a table card, one way is to drag that same column in again as the 1st column and choose count. Then in the chart properties, General - Hide Columns, enter 1. This will hide the 1st column and the aggregation that you chose will remove the duplicates.

Zel

Hi, @MarkSnodgrass, I'm using a grouped bar chart. Is there a way to achieve this?

MichelleH

@Zel How do you currently have your grouped bar chart set up in analyzer and how do you want it to look? If you just want a single bar per tech name, then I'd suggest using a stacked bar chart with Tech Name on the X Axis and removing any sort fields. A grouped bar chart is best for if you wanted to see values for each tech name over time, so it would make sense that your tech names are duplicated in the card.

Zel

Hi @MichelleH. It should look like this:

MichelleH

Zel

Wow! @MichelleH thank you so much, it looks perfect! :D