1. The end of line trend indicator can provide an effective visual hint in dashboard.
    Sometimes your axis is busy with dual charts. So you don't have the luxury of using dual axis to create an end-of-line trend indicator. Here we are going to show that you don't need dual axis to do that.

    The trick is easy: put it inside the Label.

    This is how the last variance is calculated:
    Put it in the Label:

    Here are a couple variants of implementation:
    - Custom Number formatting ;●;
    Select red color for the font in the Label. If you want to use arrow to be the indicator, try this.
    - Calculated field
    The above is equivalent to a calculated field as follows [Last Delta Indicator]

    • If [Last Delta]<0 then "●" end

    Issue of alignment
    There is a little issue of alignment if you want it to be perfectly on the data mark. We found a few ways to approximate the perfect alignment:
    - Select middle and center alignment for the label.
    - Use vertical font directions
    - Adjust the axis scale so that the end point is not at the lower edge of the axis.
    Here is a link to an example workbook. Try it.
    That's it. Hope it works for you.
    5

    View comments

  2. When clicking the download button for a viz on Tableau Server or Tableau Public, we often see that the data and crosstab options are greyed out.

    What should we do about it?

    First, we have to understand that a dashboard is composed of multiple worksheets or charts. Each sheet or chart has its own data set. One has to be specific on which data set to download.

    Second, click on a specific chart/table/sheet and then go to download button. You will see the data and crosstab button being active. Try it out on this viz which has got 2 charts: tiled map and zoom window. You can click either one to download data.
    Data for the tiled map:
    Data for the zoom window:
    That's how we can download data for each of the charts in a viz.
    0

    Add a comment

  3. Just wrote a post on Placing Labels on Tiled Map last week. Again, found that this tiled map has non-aligned labels by Michael Mixon. Otherwise, it is a great viz with very good uses of dual axis, color schemes and drill downs. BTW this viz is part of the #MakeoverMonday week33 project.
    Seems like that placing labels in an aligned position on tiled map has been a challenge for many.

    We can't use dual axis as described in the previous post, since it's already been used in this viz. We have to find another way.

    A close look revealed that the original label was laid on the area chart at year 2009:

    • IF MIN([Year]) = 2009 THEN ATTR([US Tile Map].[Abbreviation]) END

    The data mark at 2009 is of variable height for different states. This makes the label position variable, thus non-aligned.

    Instead, the value of the other axis [% Change since 2003] at year 2003 is invariably zero for all states. So we made the following change:
    1.Change the formula to:
    • IF MIN([Year]) = 2003 THEN ATTR([US Tile Map].[Abbreviation]) END
    2.Move the label to the other axis which is a bar chart.

    Now we have an aligned state label for each of the tiles. Click image to view the interactive version.
    The key here is to found a common data mark in all tiles, and place the label on it. In case we couldn't find one, we may create one in some way.

    To summarize, there seem two options to create labels in tiles:
    1. Dual axis: create a single mark measure that's fixed over all tiles.
    2.When dual axis is already used, try placing labels in the Label/Text shelf of one data mark, which is common in all tiles.

    BTW, made some tweaks to the Zoom window to provide a bit more details.

    That's all for this tweak.
    0

    Add a comment

  4. Georgia Chen created a tiled map for a recent #MakeoverMonday project. She had a hard time placing the labels on the tiles. And she ended up doing it manually. Yes, you can drag and drop the labels to a place manually.
    Tiled map is often used chart type, which is a kind of small multiples. In a tiled map, there is always a label in each tile to indicate the actual location or the category of the tile.

    How to place the label at a desired position? The general approach is to
    - create a single mark chart at a desired position.
    - put the label on the mark
    - dual axis with the existing chart.

    Georgia already used dual axis to place a colored arrow at the end of line chart. I moved the arrow to the label using a number formatting technique. So I saved the dual axis for later use.

    Position the tile label
    Each tile here represents a state (or a union territory) in India. Note that the horizontal axis is year, and the vertical axis is a percentage. To place the label at the upper center, I created a measure [Mark] as follows:
    • IF [Year]=2014 THEN 0.8 END
    This will place the mark at year 2014 and at the height of 80%. We select white color to hide the data mark so that it is not visible. Last, place State (Group) on the Label shelf.

    Aggregate the measure Avg(Mark)
    The dimension State (Group) is being used instead of State because of recent state readjustment. Andhra Pradesh and Andhra Pradesh (New) are grouped together. Sum(Mark) would have produced 1.6. We need to use Avg(Mark) to keep the mark at 80%

    Dual Axis and synchronize
    Place Avg(Mark) at the Row shelf. Dual axis with the main measure. Sync the scale with the main axis. We get the labels in the desired place.
    Voila the tweak of the week.
    0

    Add a comment

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.