2 Replies Latest reply on May 9, 2018 1:18 AM by Elmurat Bavlankulov

    Fixed LOD for viz in tooltip

    Elmurat Bavlankulov

      Hi All,

       

      Thanks in advance for helping me with my question.

       

      In first worksheet I have a text table with [Names] and [% share of Orders] from total (Table Down) for selected one date.

       

      In second worksheet I have a text table  with [Names] with MTD (until that selected date) [% share of Orders] from total (Table Down). (So I see share of each Name for given date)

       

      So what I want to do is, create a Dashboard, where the second worksheet will be in the tooltip of the first one (Viz in Tooltip) but as a line chart for given [Name].

      When I hover over the [% share of Orders], I will see MTD line chart of [% share of Orders] for given [Name].

       

       

      The issue is, when I hover over the [% share of Orders], the viz in tooltip line chart shows me [% share of Orders] from total (Table Across) for that [Name] but not for the date on MTD (Table Down).

       

      Instead I need to see numbers that are in the second worksheet for given [Name].

       

      I guess I need to use LOD Fixed, but unfortunately couldn't figure it out how exactly.

       

      Hope I could explain understandably.