topic Distinct of 2 columns in Dashboards & Analytics Discussions

Distinct of 2 columns

Spd_03 — Mon, 24 Apr 2023 06:54:41 GMT

Can we create a column which calculates distinct of 2 same columns but with different filter?
Consider Column_1 is having a filter Filter_1 and Column_2 is having a filter Filter_2, here both the columns are same but filters are different. Also filters are coming from Presentation Variables.

I've tried to create one but distinct function requires second parameter as Group By.

Re: Distinct of 2 columns

Wadeyy03 — Mon, 24 Apr 2023 13:30:23 GMT

Hi,

Using formula Builder and presentation variables ->

Using the distinct function on a case condition considering the presentation variables and grouping by the region

(P.S it is +1 because it considers the else condition as well ("NULL"))

Re: Distinct of 2 columns

Spd_03 — Mon, 24 Apr 2023 13:56:03 GMT

Hi @Wadeyy03 ,

Thank you for the reply, I've tried to implement both the approaches but there is slight data variation between 2 approaches.
Is it due to formula builder or any other reason??

Re: Distinct of 2 columns

RADSr — Mon, 24 Apr 2023 17:31:04 GMT

Alternate: In an insight drag the column to the measures area - twice. Open the measure property and drag a formula to the "filter" target:

It's a nice feature. Note: I think you'll find it's only available for aggregated measures. If it needs to be repeatable ( e.g. "Sales for California" ) make it a formula column in the schema. You'll wind up w/ a bunch of formula columns, but runtime performance will be better.

Re: Distinct of 2 columns

Wadeyy03 — Tue, 25 Apr 2023 06:12:30 GMT

Hi Spd_03,

It might be because of my data but maybe it is considering the "NULL" as well somewhere.