5 Replies Latest reply on Apr 4, 2017 7:06 PM by Kashish Chauhan

help formula for: by [variable], if [variable1] = 1 then [variable3]

Leslie Raillon Apr 4, 2017 6:53 AM

Hi,

I have a tricky formula I would like to create.

Here is what I need looking at this database:

User_ID	Nth_Device_Id	Nth_device_type	Nth_device_family	Nth_Device_retailer_id	Nth_Device_country	Nth_Device_date_setup	Delay	RANK_with_accessories	RANK_without_accessories
1A	1B	NACamera	Main	Bob	FR	25/02/2015	483	2	2
1A	2B	NACamera	Main	Bob	FR	26/05/2015	573	3	3
1A	3B	NAPlug	Main	Bob	FR	04/09/2015	674	4	4
1A	4B	NAPlug	Main	Bob	FR	30/10/2013	0	1	1
2A	1B	NACamera	Main	Martha	FR	26/01/2016	0	1	1
2A	2B	NOC	Accesory	Martha	IT	29/11/2016	308		2

I would like to add a new column in Tableau, "1rst device type": by same user_id, if "rank_with_accesories" = 1 then "Nth_device_type"

Any idea?

Thanks a lot,

Regards,

Leslie

Database for forum request.xlsx 9.0 KB

1. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Kashish Chauhan Apr 4, 2017 6:58 AM (in response to Leslie Raillon)

Hi Leslie,

Are you looking for this?
Like Show 0 Likes(0)

Actions
2. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Leslie Raillon Apr 4, 2017 7:03 AM (in response to Kashish Chauhan)

Yes...

BUT:
"First Device" should be
NAPlug
NAPlug
NAPlug
NAPlug
NACamera
NACamera

So by user, all rows are completed.

Thanks

Regards

Leslie
Like Show 0 Likes(0)

Actions
3. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Kashish Chauhan Apr 4, 2017 7:30 AM (in response to Leslie Raillon)

Use these two calculations:

First Device Type:

if [rank with accessories] = 1 then [Nth device type]
end

Now to fill each row for the user with the above value use this calculation:

{ fixed [user id] : min(first device type)}

Thanks
Kashish
Like Show 0 Likes(0)

Actions
4. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Leslie Raillon Apr 4, 2017 8:07 AM (in response to Kashish Chauhan)

Hi,

THanks that works really well.

One question though: i have a case where for one user with 2 products A and B which are activated at the same time.

So their really is no first product.

First "first device type" I get :
for A A
for A B
for second calculation (when i use f"ixed"), I get:
for A A
for A A
how does he determine which one to keep? does min formula use an alphebetical rull in such a case?

Thanks

Leslie
Like Show 0 Likes(0)

Actions
5. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Kashish Chauhan Apr 4, 2017 7:06 PM (in response to Leslie Raillon)

Hi Leslie,

Yes you can say that. If only one product was there after a condition gets true than the Min and Max value would have been the same. If you feel I have helped you in any way please mark my answer correct so that it is removed from the "Unanswered threads".

Thanks,
Kashish
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

help formula for: by [variable], if [variable1] = 1 then [variable3]

1. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

2. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

3. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

4. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

5. Re: help formula for: by [variable], if [variable1] = 1 then [variable3]

Actions

More Like This