-
1. Re: How to add one KPI Column to data table
Joe Mako Sep 2, 2011 9:21 PM (in response to . spoloms1)There are a few ways to make that display in Tableau.
If you can supply a sample data source that represents your situation, an example workbook can be made for you.
-
2. Re: How to add one KPI Column to data table
Ryan K Sep 27, 2011 12:21 PM (in response to . spoloms1)Hi Joe,
What would you suggest? Can you dummy-up a simple data set for illustrative purposes?
Congrats on your recent mention in the news!
-
3. Re: How to add one KPI Column to data table
Joe Mako Sep 27, 2011 12:38 PM (in response to . spoloms1)attached is an example workbook with some layout tricks to get a result like the image.
-
kpi_layout.twbx 29.7 KB
-
-
4. Re: How to add one KPI Column to data table
guest contributor Oct 4, 2011 1:57 AM (in response to . spoloms1)Hi Joe,
how do I get the multiple Marks? and how to associate the symbols "up" and "down"?
Thanks
-
5. Re: How to add one KPI Column to data table
guest contributor Oct 4, 2011 6:58 AM (in response to . spoloms1)Is there a simpler way to do this without the NULL kludge, etc?
Or is Tableau not really capable of doing this in a more extensible way (by this I mean, if I had more KPIs this would be a pain to setup and not very easy to change).
What other capabilities does Tableau have for displaying KPIs along with a trend indicator and a reference point (last 3 mos, etc)? Thanks!
-
6. Re: How to add one KPI Column to data table
Michal Strelec Sep 6, 2012 4:54 AM (in response to Joe Mako)Joe,
Column widths in your example are connected so in case I will resize the numerical columns (two last) it would change the width of the column with the symbol. Is there a way how to keep symbol column width fixed and enable resizing other columns?
Regards,
Michal
-
7. Re: How to add one KPI Column to data table
Alrich Lynch Jun 11, 2013 1:08 PM (in response to Joe Mako)Joe,
I have a similar question. In my case, the data will be coming from a client on a semi regular basis. I don't want to have to calc in excel, I'd rather Tableau do it (I say that now, not knowing the extent of what a similar formula may be in Tableau). Ideally, I'd just do a refresh and let the new data populate, etc.
I've attached an image of what I currently have in Tableau. I see that it can do the table difference calculations, but it looks like that requires the table to be visible, as opposed to bars or lines, etc. so that may not be an option. I'd like to show the KPI symbols in a column similar to your example. I did a calculated field and then drug that to the column shelf to create the columns containing the symbols. I'm thinking there must be an easy formula that basically says, if the value for year 2012 is greater than 2011, then use down symbol. Alternately, if the value for year 2012 is less than 2011, then use up symbol. I assume that I'll then be able to add color to the symbols. Green = Up and Red = Down.
-
8. Re: How to add one KPI Column to data table
Shawn Wallwork Jun 11, 2013 1:20 PM (in response to Alrich Lynch)Alrich, post from before the New, New forums don't ping participants any more so Joe Mako won't know you asked him a question. I just pinged him for you.
--Shawn
-
9. Re: How to add one KPI Column to data table
Alrich Lynch Jun 11, 2013 1:31 PM (in response to Shawn Wallwork)Thanks
-
10. Re: How to add one KPI Column to data table
Joe Mako Jun 11, 2013 4:46 PM (in response to Alrich Lynch)Can you please provide a sample packaged workbook with data that represents your situation, and detail what you expect for results and interaction? Thank you.
-
11. Re: Re: How to add one KPI Column to data table
Alrich Lynch Jun 11, 2013 5:42 PM (in response to Joe Mako)See attached as well as original excel file.
On tab ! - Ideally, the Arrows would exist where there is now "Down". I must have a the "Change (Cost)" Calculated field wrong b/c it shows all as "Down" but Atlantic Station ... obviously went up $1,734 in 2011 to $17,60 in 2012. I feel like I am so close.
I picked up a few ideas on the calculated fields from the previous example you gave.
-
Sample_KPI Info.xlsx 18.1 KB
-
KPI_LEED Example.twbx.zip 53.7 KB
-
-
12. Re: Re: Re: How to add one KPI Column to data table
Joe Mako Jun 12, 2013 8:14 PM (in response to Alrich Lynch)2 of 2 people found this helpfulThere are a number of things going on, the top priority is awareness of your dimension pills. I cannot stress this enough, without awareness of your dimension pills doing things in Tableau will get confusing quickly.
Starting from your worksheet "1", perform the following:
1. Remove the discrete dimension pill "YEAR(Date)" from the Marks card
This will cause your "Change (Cost)" pill to compute correctly, but will now give you incorrect labels, and remove the coloring
2. Place "Measure Names" on the Color shelf
3. remove the pill for "SUM(Water Cost)" from the Marks Card
4. Click on the Label landmark, and check the box for "Show Mark Labels"
5. to format these labels, select each of the continuous measure pills on the Columns shelf, and set their Format->Pane->Default as desired.
6. for an arrow mark in the Rows header area, you can use a calc field with a symbol, a formula like:
If sum([2012])>=sum([2011]) then "▲" Else "▼" end
(or use separate calcs for each to get them colored)
attached is the result of these steps.
-
13. Re: Re: How to add one KPI Column to data table
Alrich Lynch Jun 12, 2013 10:21 PM (in response to Joe Mako)Joe,
Thanks alot. I was able to duplicate. I had to copy the arrow symbols from your file, not sure how you did that. I tried to copy an arrow "symbol" from MS Word, but that didn't work.
Anyways, I think I understood everything except the first step - why does the dimension pill have such an effect?
I don't think I would have every figured this out. Bravo and Thanks.
-
14. Re: How to add one KPI Column to data table
rana naskar Feb 5, 2015 8:34 AM (in response to Joe Mako)