How to Split a Measure in Tableau?

0 votes
Does anyone know how to take one measure and split it into two new measures. So that the first measure will include only positive numbers, the second will contain only negative numbers.
Aug 13, 2018 in Tableau by Naruto
• 710 points
138 views

1 answer to this question.

0 votes

Have you tried using an IF statement:

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

Let me know if this works for you.
answered Aug 14, 2018 by AwesomeSauce
• 860 points

Related Questions In Tableau

0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
1,920 views
0 votes
1 answer

How to sort by any measure in a Tableau table?

Hi Sindhu, Once you have created a bar ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 31,840 points
713 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,248 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
1,296 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
64 views
0 votes
0 answers

Calculating count average from averages

I've a calculated field in Tableau which ...READ MORE

May 28, 2018 in Tableau by Mahima Choudhary
29 views
0 votes
1 answer
0 votes
1 answer

Sum of previous two months sales where the current month is entered by the user.

It can be achieved easily by creating ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
239 views
0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 860 points
89 views
0 votes
1 answer

How to select column which are needed to create report in tableau

Please follow this process: Make database connection Join tables Go ...READ MORE

answered Sep 26, 2018 in Tableau by AwesomeSauce
• 860 points
44 views