Count of negative profit and positive profit for a month

0 votes
Can anyone help me to create a chart to show count of positive and negative profits on a monthly basis for each day?
May 20 in Tableau by Anitha
40 views

1 answer to this question.

0 votes

Hi Anitha,

It is easy and simple. Follow the below steps:

1. Create 2 Calculative fields to categorize the orders into positive and negative profits.

IF [PROFIT]>0 THEN [ORDER_ID] END similarly with -profit group

2. Now drop the two fields in the row self and select aggregation as count.

3. Drop the date in col shelf, you can either use a parameter or filter to filter days for a month. I used a filter to show day profits for a month for a year.

4. Now Double click on the field with - profit group and enter a - symbol in front of count function.

5. Now you would get a bar graph like this.

6. Edit the bar color and add labels.

Hope it helps you.

answered May 20 by Cherukuri
• 32,260 points

Related Questions In Tableau

0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
3,911 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
193 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 32,260 points
30 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,376 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

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

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 32,260 points
34 views
0 votes
1 answer

How to aggregate and count the occurrence of TRUE and FALSE?

Hi, you can do any of below ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 32,260 points
108 views