1 Reply Latest reply on Apr 29, 2016 7:10 AM by Santiago Perez

    Fixed{} with non-obvious hierarchies

    Santiago Perez

      Hi Everyone,

       

      Struggling with LOD expressions. I'm looking to create a benchmark which provides an average for each unique value in the question table, ignoring fields in the account table below:

      if I use {exclude Account Name:AVG(Response)} and then split by question I get exactly what I want. The problem? Applying an account name filter to the viz then messes up exclude (i get the average for the companies selected, I want the average for all companies), only the fixed lod gets applied before a dimension filter.

       

      But Fixed{Question Name:AVG(Response)}} is not working. Its easy to see how fixing the level of detail at region would prevent aggregation at the city level or the same from quarter to month, but with a data model like the one above, how can I achieve my objective?

       

      Thanks!