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, 2019 in Tableau by prakash
324 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, 2019 by anonymous
• 33,010 points

Related Questions In Tableau

0 votes
0 answers

Tableau - KPI (Forms) using different variables

As seen in the excel example below, ...READ MORE

Apr 18 in Tableau by Neha
• 8,920 points
61 views
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 29, 2018 in Tableau by sdfg
• 5,550 points
1,610 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,190 views
0 votes
1 answer

Tableau Vs Qlikview

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points

edited Mar 30, 2018 by QueenBee 162 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,230 points
8,225 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,230 points
856 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 28, 2019 in Tableau by Cherukuri
• 33,010 points
889 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, 2019 in Tableau by Cherukuri
• 33,010 points
8,102 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP