Tableau - Split a measure into measures (one for negative numbers, one for positive numbers)

Question

Does anyone know how to take one measure and split it into two new measures. The first measure will include only positive numbers, the second will contain only negative numbers.

I have tried creating a group. This makes the new group a dimension, the only way I can switch it back to a measure is by doing a split first. Makes no sense to me. Bins also doesn't work.

score 1 · Accepted Answer · answered Mar 27 '18 at 16:04

1

Have you tried using an IF statement:

IF {measure > 0} THEN 'Positive' ELSEIF {measure < 0} 'Negative' END

answered Mar 27 '18 at 16:04

Jaime Hutchins

46
8

score 1 · Answer 2 · answered Mar 27 '18 at 16:35

1

Create two calculated fields:

Positive measure

if measure >=0 // including values with 0 in positive
then measure
end

Negative measure

if measure<0
then measure
end

answered Mar 27 '18 at 16:35

Siva

9,043
12
40
63

Tableau - Split a measure into measures (one for negative numbers, one for positive numbers)

2 Answers2