1 Reply Latest reply on Nov 9, 2018 9:28 PM by Shinichiro Murakami

    Adding scorecards

    Danish Haroon

      Hello

       

      For the purposes of this analysis, 3 fields are of significance:

      • Date:1/1/2017 - 12/31/2018
      • Expense Total Amount: Measure values available for dates 1/1/2017 - 8/31/2018
      • Expense Predicted Amount: Measure values available for dates 9/1/2018 - 12/31/2018

       

      One scorecard should display the Expense Total Amount for the latest non-null year i.e. 2018 in this case. This doesn't has to be hard coded, whereas the logic should check for the latest non-null year for Expense Total Amount values and aggregate the measure for that latest year.

      The second scorecard should display the Expense Predicted Amount for the latest non-null month, and year i.e. 9/2018 in this case. This doesn't has to be hard coded, whereas the logic should check for the latest non-null month, year for Expense Predicted Amount values and aggregate the measure for that latest month, year.

      Packaged tableau file attached

       

      Best Regards

      Danish