Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

drill through using detail

Hi, in a visual i can easily drill through using the category..  In the example below  of statuses, i can easily drill through to look at the data. 
|But the numbers are based on the count of each ID. When I bring this status into the drill through category, works great. But I want to use the ID instead, to drill through to the page (there are multiple ID's in each of these Statuses.

Any idea how i can achieve it? It ignore the drill through, despite putting the ID field in the drill through page,

 

Need Help

5 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    4 years ago

    Hey Anonymous ,

     

    I guess I do not fully understand your requirement.

     

    Assuming your report has two pages

    1. The first is called summary and contains the chart from your post
    2. The second is called detail and contains a table visual
      The table contains the id-column and some measure or numeric columns.
      On the detail page, you add the status column as drill through column.

    If you initiate a drill through from the chart on the summary page, just the IDs that form the status should be visualized in the table visual on the detail page.

     

    Does the above not work or do you want something completely different.

     

    Regards,

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I think you basically got it. 
    There's no issues when doing drill down by the legend (Status in this example). But the values that make up the Status, the ID's, i want to drill into my table using those values, rather than the status itself.
    It currently ignores it when I try, despite adding the ID field that populates the visual, or the ID that's on the main table.

    Did i explain it clearly?

    • TomMartens's avatar
      TomMartens
      Super User
      4 years ago

      Hey Anonymous ,

       

      please excuse, but I'm slow.

      I do not understand what you are looking for.

      Can you please describe the visual on the summary page, and the visual on the detail page.

       

      Regards,

      Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    This seems to be impossible to achieve. You must have drilled fields in your page as the target before you can drill.

    You can try to set the font color and background color of the City field to white to make it look like this, and you can continue to drill.

    Field formatting-select the City field-Font color and Background color are both white.

    Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.