Hello Alex, You file has the scroll bar but it doen't give the functionality to zoom -in/out the chart.
I've attached a demo of Zoom slider available in Spotfire (It helps to view the trend as per month & then drill it down to day level using zoom slider within single view. Also helps to focus on target from multiple value range.
Spotfire Zoom Slider.swf 1.8 MB
I don't have a stand alone flash player unfortunately - is there a web page with it somewhere?
2 of 2 people found this helpful
Here's one way to do this in Tableau… The only slider range selectors (my term for the Spotfire Zoom slider) available in Tableau are for continuous filters. It's easy enough to set a continuous date filter on the date to get the bottom chart, the tougher one is the top chart since the bars are based on discrete values. The idea I came up with was to generate a range of numeric values to correspond to the discrete bars. In the attached, what I did was:
1. Set up the "rank workout" worksheet with an INDEX() calc rank the Sub-Category dimension.
2. Used those result to create a CASE statement in the original data set to return the right value, I called this "Sub-Category Rank by Sum of Sales". In practice, what I'd most likely do is put steps #1 and 2 into SQL, so they could be dynamic. Also, in Tableau v8 parameters can be used within the SQL so the sort order could be dynamically updated.
3. Used a continuous dimension of the Sub-Category Rank quick filter as a global filter. In Tableau v8, this wouldn't have to be a global filter and could just target the worksheets on the dashboard.
4. Put a dashboard together with the worksheets in the order as shown in the video.
A couple of other options that I considered that didn't work:
- Just using a filter on INDEX() - this is great for filtering the first worksheet, but does not work for the second because table calc filers can't be used across worksheets.
- Using a data blend. In this case I computed the INDEX(), then copied & pasted the data to create a datasource that would get me the rank. This works fine in the first worksheet, but fails to work across worksheets because the field used for the blend (Sub-Category) doesn't exist in the line chart worksheet. This might work in v8, and there are workarounds using table calcs in v7, but either way it's still not a dynamic solution.
- Using a filter on SUM([Sales]). This also works for changing the range of displayed bars, but as a global filter it's acting on the SUM([Sales]) within each view so it's not actually removing different categories from the view per se, it's filtering out marks (whether dates in the line chart or sub-categories in the bar chart) that don't match the filter settings.