Search code examples
tableau-apitableau-desktop

Setting tooltip to show specific dates based on the field it hovers over?

Is it possible to filter what a tooltip displays based on the content it hovers over?

I am building a progress-tracking dashboard for various projects. I have a view that displays the completion by each department for each project stage (Project Completion Table).

enter image description here

I also have a table with the start dates of each project stage (Project Dates).

enter image description here

I wish to have the start dates for each project stage displayed on the tooltip based on the different project stage completion bars that the user hovers over.

enter image description here

Link to sample workbook: https://drive.google.com/file/d/1T2O07FHAjN75H4tP03zraYLwrXOOPmiv/view?usp=sharing

Thank you in advance!

Solution

  • Try this first; Drag [Design (sample data2)] to your tooltip in the marks pane.

    If this does not give you your desired output then continue reading.

    Using a FIXED LOD expression:

    Create a calculated field fixed to the project stage level of your data.

    {FIXED [project stage /*which I assume is your pivot field names from your images*/] : MIN([Project Dates]}

    Note: the MIN is only there as FIXED expressions need to return an aggregated value.

    Drag this calculated field to your tooltip in the marks pane.