DATA HAWK
  • portfolio
  • Projects
    • National Day
    • 12 Days
  • blog
  • favorites
  • about

SET ACTIONS - Reference line highlighting

11/2/2018

0 Comments

 
Picture
​Set Actions Part Two! In this example we use Set Actions to specify a date range. We will then use the set to highlight color and filter other graphs on the dashboard.
Tip 1: Highlighting a timeline using reference line
1)  Create a calculated field based on the level of desired detailed for your timeline – in this case I used month and year:
[Month / Year]:  DATETRUNC('month', [Order Date])
2)  Create a set based on the new field above
3) Create a second calculated field keeping only the date values in the set:
                [Dates in Set]: IF [Date Set] Then [Month / Year] END
4) Add the new calculated field, Dates in Set, to the circle mark, to not break your path. 
Picture
​5) Add two reference lines:  min(Dates in Set) and max(Dates in Set).
                Color above the min reference line with a color, color above the max reference line to match the background (in this case, white).
Picture
Picture
​Tip 2: Color bars based on values in the set
Simply the set (Date Set) to the color shelf
Picture
Tip 3: Filter based on values on a set
Drag the set to the filter menu to keep values “IN” set
Picture
​As you highlight new ranges of data on your timeline, your bars and map with update to represent the dates in your range. By using the option to Keep Set Actions, you can deselect you the marks on your timeline, and interact elsewhere on the dashboard, but your set range will remain – and your audience will know the range because the timeline stays shaded.
 
Thanks for reading – let me know if you have questions!
0 Comments



Leave a Reply.

    Author

    Corey Jones  | @coreyj34
    Data Viz Enthusiast 
    Philadelphia Area
    ​coreyjones012@gmail.com


    Archives

    December 2018
    November 2018
    October 2018
    January 2018
    June 2017
    April 2017
    December 2016
    November 2016
    September 2016
    July 2016

    Categories

    All
    Instructional

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • portfolio
  • Projects
    • National Day
    • 12 Days
  • blog
  • favorites
  • about