Blog

27
JAN
2016

Dynamic Traffic Lights

Kommentare : 0

Today I want to share an idea about how to visualize targets. There are a bunch of different ways to do so. If the data is already part of your CRM solution or data warehouse – just take this information and represent it as bar, bullet graph, traffic light…you name it. If this is not the case you could go with a parameter which every salesperson in your company can use to actually change the target to the individual one. Now you might think…well, but I need to change this target each and every time one is opening the report. This is not the case! If you’ve got Tableau server in place you can easily save a “custom view” and making this your personal “default view” (for this report). This means each and every time “user A” is opening the report/dashboard, user A will see the target he has set last time. The same applies for everyone else.

Next to the concept of parameters and how you can leverage them I’ve used a concept which is known as “proportional brushing”. This allows you to compare the performance of a region, salesperson, product, etc. against the overall performance. The example dashboard which you can open by clicking on the picture below is showing this over time. So how can you adopt this? Well just download the workbook and try to re-engineer it. You basically need to:

 

 

  1. Right click on your date –> Create –> Custom Date –> “Order Date (Month / Year)”
    • This creates a field which just contains month/year
  2. Create a calculated field –> “{ FIXED [Order Date (Month / Year)]: SUM([Sales])}”
    • Represents a Level Of Detail Expression (LOD) which fixes sales to this time dimension
  3. Create a dual axis chart which is containing sales and your calculated LOD
  4. Put this sheet as well as another sheet which works as a filter on a dashboard to see the individual performance compared to the overall performance
Timo Tautenhahn
Über den Autor
Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API

Teilen

  • google-share

Kommentare Cancel reply

*

*

captcha *

Categories

  • Admin Area (1)
  • Data Stories (1)
  • Developer (2)
  • Embedding API (2)
  • Extension API (11)
  • Geek Stuff (3)
  • Hacks (1)
  • Ideas (8)
  • Industry Related (1)
  • Neuigkeiten (6)
  • News (3)
  • Performance (2)
  • Salesforce (1)
  • SAP (1)
  • Success Stories (1)
  • Tableau 10 (1)
  • Tableau 9 (1)
  • Tableau Server (3)
  • Tableau Visualization Extensions (1)
  • Tipps & Tricks (10)
  • Tips & Tricks (1)
  • Tutorials (14)
  • Visual Inspiration (8)

Tags

artilize Azure bericht Cloud Cloud Database conference Datalake dynamisch embed Embedding Extension API Extract API html javascript api kpi mobile munich news on-demand on-tour parameter RLS Salesforce SAP SAP BW Security Snowflake SSO tc Write Back

Last posts

Timo Tautenhahn - Tableaufans.com - Tableau Visualization Extensions - Create and share your own chart types - Live Devs on Stage TC21

Tableau Visualization Extensions

Thursday, 11. November 2021

How to configure Tableau Online Single Sign-On with Salesforce as Identity Provider?

Monday, 16. November 2020

Tableau Extensibility Framework

Thursday, 17. September 2020

Embedding Tableau Responsively

Tuesday, 26. May 2020

Show Empty Rows and Columns

Tuesday, 24. December 2019
  • Blog
  • About
  • Contact
  • Legal
© 2019 - tableaufans.com - All rights reserved
Concept and design: www.emodia.de