4 Replies Latest reply: Jun 23, 2016 10:20 AM by Stefan Wühl RSS

    GetSelectedCount for Date

    Kandu Group

      Hi all,

       

      I'm trying to build a dashboard with a KPI that should show the sum() for the specific date ('2015-05-18')  at the opening of dashboard or when no other date is selected but also if the user select one specific date from the bottom chart it should then show the sum() for that date.

      I thought GetSelectedCount would be the easiest way about but and I could get it right for when the specific date(s) are getting selected but it doesnt show the correct amount on the opening of the dashboard and when no date selection is made.

      Sum(${<EVENT_DATE={'$(=If(Getselectioncount({'EVENT_DATE'})=0, {'2016-05-18'},{'EVENT_DATE'})'}>}

      TOTAL_DISCREPANCY_VALUE_OVER)

      Screen Shot 2016-06-23 at 2.02.55 PM.png