10 Replies Latest reply on Sep 16, 2016 12:50 PM by Alex Xu

    How to find / count Dimension based on Measure value

    christopher jones

      Hi all,  I'm stumped on this one and hope it's an easy solution for the experts.  The data/viz I'm working with is below.  The goal is to provide a count of projects by current phase.  Current phase is identified by the earliest Plan Completion date having either Null Actual Completion or OpenFilter='Open'.

       

      The example below would return 1 project in Measure and 1 project in Improve.  Any assistance is much appreciated - Chris