2 Replies Latest reply on Nov 7, 2018 3:37 AM by Sridhar S

    Need help in Tooltip expansion?

    Sridhar S

      I am working on building a problem report for all the incidents.

      I am stuck at one point where I am unable to use the tool-tip effectively.

       

      Below are the fields that I have in Rows.

      Incident #/ Problem #/Short Description/Start time/End time/Root cause/Corrective Action#/Short Description

       

      If you see the problem I am facing is there are many incidents for which there are more than 1 Corrective actions available

      So the Tool-tip column also splits into # of rows as per the # of corrective action item. For example: if there are 3 corrective actions for an incident, then there are 3 rows created under that incident. And thereby 3 tool tip rows gets created and each tool tip column shows all the rows + that specific corrective action item.

       

      What I wanted is to have a single tool tip to show all details + also all individual corrective action items associated with any specific incident.

      Is this possible?

       

       

      Incident #/ Problem #/Short Description/Start time/End time/Root cause/Corrective Action#/Short Description

       

      ABC XYZ  Printer not working  9/16/2018 5:30 AM 9/16/2018 5:50 AM  Problem with ink  CA1 Modify the inkjet  Tooltip1

                                                                                                                                                      CA2 Check the ink level periodically  Tooltip 2
                                                                                                                                                      CA3  Renew the agreement with vendor  ToolTip3

       

      I have described my scenario above. CA refers Corrective Action. SO 3 Corrective actions discovered for a single incident. But there are 3 tooltip column that the report has and not a single tooltip to show all CA for that incident. Need help on this.

        • 1. Re: Need help in Tooltip expansion?
          suresh.gooty

          yes it is possible but you need to play bit different in this scenario. normally tooltip works based on row... for your data and scenario of master/detail or parent or child you need to create one additional sheet where it will display only related incident details details. in mouse hover action of incident you need to add filter so that the other sheet will display only that incident details. and the main tip and technique here is when you place your mouse in that incident it should display other sheet where it is displaying subsequent details of your incident... for this in toolTip you have option called insert sheet . with that insert sheet you need to add your detailed additional sheet which you created for other purpose. hope this will give you the exact result which you require to display the data in tool tip. this is the workaround for the logic which you requested. if you agree my option you can click on helpful or correct answer so that i also will become famous by giving answers to those who are in real need of problems... I am calculations expert in tableau... especially with functions.... Best of Luck...

          • 2. Re: Need help in Tooltip expansion?
            Sridhar S

            Created a New sheet with following 5 fields (all in rows)

             

            Incident#/CA#/Short Desc/CA status/Due date

             

            Then selected
            Worksheet->Actions->Hover->Source sheet(New Sheet)-->Target Sheets(Old sheet)-->All new fields in New Sheet selected.

             

            Then I went to My old sheet and Worksheet-->ToolTip-->Insert New sheet (Sheet name "New Sheet") and then on mouse hover it displays all my previous tooltip contents + just the sheet name "New Sheet".

             

            Am I doing something wrong. Can you kindly show some screenshot to address any misunderstandings.