3 Replies Latest reply on Oct 24, 2018 7:45 AM by Ombir Rathee

    toggle between daily, weekly, month end views

    Kristy Becker

      User needs to be able to toggle between daily, weekly, month end views for audit purposes.  The user
      is not comparing daily, weekly, monthly data sets.   Need only 1 report / 1 sheet to show different snap shots based on a possible date filter.

       

      Database Objects: 3 tables –

      • Table 1 contains daily snapshot of a rolling 7
        days data set
      • Table 2 contains weekly snapshot of a rolling 6
        weeks data set
      • Table 3 contains month end snapshot of a 12
        rolling month data set

       

      Looking for best approach.

      1. Create custom sql union in the data source

      Select Record Date, Daily Indicator, Store, Inventory from Table 1

      Union

      Select Record Date, Weekly Indicator, Store, Inventory from Table 2

      Union

      Select Record Date, Monthly Indicator, Store, Inventory from Table 3

       

      Create one report/sheet so the user can
      toggle easly between data views

      1. Use a data filter / parameter or the Indicator

       

      1. Use Data Blending?
      2. Suggestions…..