1 Reply Latest reply on Oct 15, 2018 3:07 PM by Andrew Bickert

    Dynamic dashboard with million of records

    Tulu Sahoo

      Hi,

       

      My requirement is to build a dashboard form a table having million of records, around 1.5 million rows for 1 day.

       

      Dashboard will be in cross tab form with one dimension and 4-5 measures with dimension as filter.

       

      As i told for one day 1.5 million rows, so i want to show some sample data on dashboard like 30-40 rows of data and when user selects or enters something in filter sample data should get hidden and data corresponding to filter should appear on dashboard.

       

      Let me know if there is a way to achieve this in Tableau.

      Thanks in Advance!!

        • 1. Re: Dynamic dashboard with million of records
          Andrew Bickert

          Hi Tulu,

           

          Do you have a sample workbook by chance?

           

          Does that sample data need to come from the same date as the 'real' data? If not, you could create a calculation that looks at a parameter to choose which data to show and have the parameter be the filter. For example, if the filter needs to be 'Color', you could have the default parameter value be 'Choose Color' then have a calculation that says:

           

          If([Color]="Choose Color") then [Sample_Data].[Colors] Else [Live_Data].[Colors] end

           

          Andrew