KPI - Tableau

0 votes
HI, I want to show arrows for every increase or decrease of sales and profit from the previous row. Can someone help.

I want to show green up and red down arrows for the increase and decrease.
Jun 17 in Tableau by prakash
19 views

1 answer to this question.

0 votes

Create a calculated field as below,

IF ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1) >=0 THEN "Increase" ELSE "Decrease" END.

Replace sales by profit for profit KPI similarly.

Drop the above field in shapes shelf and select the respective arrow marks from shape shelf.

answered Jun 17 by anonymous
• 17,870 points

Related Questions In Tableau

0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,530 points
323 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
417 views
0 votes
1 answer

Tableau Vs Qlikview

Tableau is mostly used as a reporting ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points

edited Mar 29, 2018 by QueenBee 19 views
+1 vote
1 answer

Is it possible to access or install tableau desktop insde tableau server?

Try to understand this, Tableau Server and ...READ MORE

answered Mar 29, 2018 in Tableau by xyz
• 1,550 points

edited Mar 29, 2018 by xyz 44 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
1,361 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
50 views
+2 votes
1 answer
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 27 in Tableau by Cherukuri
• 17,870 points
44 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
• 17,870 points
148 views