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
7 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,940 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,200 points
18 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,470 points
46 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,470 points
72 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
68 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,200 points
948 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,200 points
36 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
• 13,940 points
33 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
• 13,940 points
9 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.