Add arrows to show increase or decrease in sales/profit

0 votes
How to add arrows and text together to show increase or decrease in sales/profit?
May 16 in Tableau by priyanka
45 views

1 answer to this question.

0 votes

Hi Priyanka,

Follow the below steps:

1. Select the marks pane from Automatic to Shapes.

2. Now create a calculated field to find the difference 

     diff = ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)

3. Now create a calculated field to group the dimension(orders/regions, etc) into 2 groups as increase and decrease.

    Arrows = IF DIFF> 200 THEN "UP" ELSE "DOWN" END

4. Now add the arrows group in shapes shelf and change the default symbols to arrows by clicking on the shape shelf.

Select Thin arrows in the drop down and select the data item and select the symbol from the symbols on the right side of the window. Then click ok.

Hope it helps.

answered May 16 by Cherukuri
• 31,840 points

Related Questions In Tableau

0 votes
1 answer

How to add filter to show latest two dates in tableau?

Steps for filtering based on the most ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
42 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,530 points
84 views
0 votes
1 answer

How can I add legends to worksheet in Tableau?

Just add the worksheet on the dashboard ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
297 views
+1 vote
1 answer

How to add grand totals of the bar in Stacked Bar in Tableau

Hi Grim, As you have used reference line ...READ MORE

answered Sep 24, 2018 in Tableau by Machdata
• 340 points
509 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,193 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
98 views
+2 votes
1 answer
0 votes
1 answer

How to show % difference between bar chart to show increase or decrease?

Hi Anshuli, Make the bar chart first for ...READ MORE

answered Apr 5 in Tableau by Cherukuri
• 31,840 points
109 views
0 votes
1 answer

How to show density map in an area or a custom geological location?

Hi Preethi, Follow the below steps to create ...READ MORE

answered May 9 in Tableau by Cherukuri
• 31,840 points
25 views