4 Replies Latest reply on Oct 30, 2018 1:51 PM by Dinesh Parthiban

    Find Dimension with 0 value for everyday

    Dinesh Parthiban

      Hi,

       

      Please help with this.  I'm unable to come up with a solution.

       

      1. List application that never had any call volume within date range (aka:C)

       

      2. Find sum of calls for application if it as call volume for at-least 1 day within date range (aka A & B)

       

      This should automatically change depending on date filter we chose.

         

      DateApplicationCalls
      1-OctA10
      1-OctB20
      1-OctC0
      2-OctA0
      2-OctB15
      2-OctC0
      3-OctA0
      3-OctB15
      3-OctC0
      4-OctA5
      4-OctB0
      4-OctC0