7 Replies Latest reply on Jun 24, 2016 5:36 AM by Tom W

    Filter broke when hiding and deleting sheets

    Joshua Preston

      I was going through a simple walkthrough to publish my viz and it busted. I deleted some unused sheets and hid all the rest. This is a simple viz with no calc fields or parameters.

       

      (I tried to retrace my steps and the only thing that might have caused this, that I know of, is that I may have deleted a sheet that was on the dashboard; I used one of that sheet's dimensions as a filter, then I deleted the sheet from the dashboard.)

       

      Here's the error. Workbook attached.

       

      (restrict

        (aggregate

          (select

            (table [Extract].[Extract])

            (= [PS Now ALL Subscrip] "Yes")

            )

          (

            ([Title (Duplicate) (group)] [Title (Duplicate) (group)])

            )

          (

            ([avg:Rating:ok]

              (average [Rating])

              )

            ([cnt:Rating:ok]

              (count [Rating])

              )

            )

          )

        ([Title (Duplicate) (group)] [avg:Rating:ok] [cnt:Rating:ok])

        )