2 Replies Latest reply: Oct 18, 2018 2:49 PM by Anthony Ventura RSS

    Multiple Expressions with Multiple Dimensions

    Timothy Kalota

      Working on a project were we a line chart with two lines (forecasted and actual).  When we drill down via some of the filters our actuals line disappears.  Two lines, forecasted and actual, click on filter and our actuals disappears.

       

      We want both lines to stay regardless of filtering.

       

      Anyone, encounter this??

        • Re: Multiple Expressions with Multiple Dimensions
          Rahul Thakkar

          Hi Timothy,

           

          The calculation will depend on how data model is associating various entities together.

          You should revisit the filters which are making actual values to disappear. You can utilise set analysis to ignore certain filters as well.

           

          It will be helpful to understand better, if you can post some example may be with sample data.

           

          Regards,

          Rahul Thakkar

          • Re: Multiple Expressions with Multiple Dimensions
            Anthony Ventura

            Hi Timothy,

            Running a quick test, I have a Line Chart with two expressions, Actuals and QuotaAmount, using Month as a Dimension. If I filter on a particular Year, my Quota disappears, which is normal.

             

            Using Set Analysis with the {1} identifier, it is possible to apply as many filters as you'd like resulting in the two expression lines staying visible.

             

            I have a feeling that your use case may be different. As Rahul said, "if you can post some example may be with sample data", that would help a lot.

            Tony Ventura