4 Replies Latest reply on Mar 23, 2016 9:04 AM by jacobo.rodriguez

# Calculate Single-Device Users VS Multi-Device users

Need some help to get the values at an accurate level.

I need to know the unique number of users that have used one or multiple devices

This is the baseline per month. Accurate values which I calculated using Excel with the same data.

This is my calculated field in Tableau:

[Users with Multi-Devices - No Date]

IF

{FIXED [Userid2]:[Count Unique Devices]=1} THEN "S"

ELSEIF

{ FIXED [Userid2]:[Count Unique Devices]>1} THEN "M"

END

The results are close, however not accurate. As you can see in Sheet 7, some of the users are wrongly counted in the month level.

e.g. user1662 had only 1 device in January, and multiple devices in February.

User1662 should be counted as

: Single-Device user in January (this is incorrect in sheet 7)

: multi-Device user in February (this is correct in the sheet 7)

Screenshot below:

Workbook attached.

Thanks

• ###### 1. Re: Calculate Single-Device Users VS Multi-Device users

Hey Jacobo,

Your FIXED calculation is ignoring [Date]. You can add it to the FIXED LoD to break it down by month.

IF

{FIXED [Userid2],[Date]:[Count Unique Devices]=1} THEN "S"

ELSEIF

{FIXED [Userid2],[Date]:[Count Unique Devices]>1} THEN "M"

END

• ###### 2. Re: Calculate Single-Device Users VS Multi-Device users

I tried that, however it is way more inaccurate. ....here are the screenshots:

SHEET 9

These are the correct values:

• ###### 3. Re: Calculate Single-Device Users VS Multi-Device users

Switch it to this and you will match it:

Month:

DATETRUNC('month', [Date])

Users w/ Multi:

IF {FIXED [Userid2],[Month]:[Count Unique Devices]} = 1 THEN "S" ELSE "M" END

• ###### 4. Re: Calculate Single-Device Users VS Multi-Device users

Thank you!

Now it is accurate.