1 Reply Latest reply on Apr 20, 2017 8:05 AM by Zhouyi Zhang

    How to exclude quick filter from secondary data source in a calculated field using level of detail expressions?

    prasad kulkarni

      Hi,

      I am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. I have quick filters of region and order date from the secondary data source.

       

      Objective:

      I am trying to calculate a calculated field for % of count of orders by region over count of orders (All region) in primary data source.

       

      My approach:

      I am using below calculation in the calculated field.

       

      COUNTD ([Order ID])/ {EXCLUDE ATTR ([Sample - Superstore - English (Extract)]. [Region]): COUNTD ([Order ID])}

       

      But the tableau is giving me error

      ‘level of detail expressions cannot contain table calculations or the attr function’

       

      Is there any another way to calculate the field.

      I am attaching a test file for recreation of the issue. Can anyone please help me on this issue.?