1 Reply Latest reply on Feb 10, 2019 1:12 PM by Yuriy Fal

    User wanted Detailed Data from the Roll up summary charts of very large data

    Sandeep Varma

      Hi Geeks, There is a dashboard based on an aggregated query in Teradata. Due to very large data(around 500 millions),designed weekly, daily, monthly & Yearly aggregated queries and now user want to see Detailed Data from the Roll up summary charts to leverage Tableau analytics. And is it possible to create an extract with this much data? What are the best ways to design without performances issues?

        • 1. Re: User wanted Detailed Data from the Roll up summary charts of very large data
          Yuriy Fal

          Hi Sandeep,

           

          The common approach is to 'navigate' to the lower-level views

          using ('cascading') Filter Actions on common Dimensions.

          This could be arranged as either several views on a single dashboard 

          or as multiple views (published with Sheets as Tabs flag enabled).

           

          The very last Filter Action would filter (jump to) the (most granular) Details view,

          which should be saved (and then published) in the initial 'empty' state --

          the respective Filter Action should have the 'Exclude all values' flag

          in the 'Clearing the selection will:' configuration section enabled.

           

          Yours,

          Yuri