3 Replies Latest reply on Nov 14, 2017 6:54 AM by Vincent Baumel

    Not able to display date for previous day aggregated data.

    sumit shukla

      Hi,

      I wanted to display date for previous day aggregated data, but I am dragging the date field into view than result getting dis aggregated.

      I am using below formula to calculate previous data occupancy.

       

      SUM(IIF([Period] = TODAY() - 1, [Total], NULL) )

      / (SUM(IIF([Period] = TODAY() - 1, [Core], NULL))

      +SUM(IIF([Period] = TODAY() - 1, [Escalation], NULL)))*100

       

      Result of this calculation is fine but I wanted to show that day as well for which I am calculating the result.

      Below is the result for 11th Nov 2017 now I wanted to show that date as well without affecting my current view.

       

      Jonathan DrummeyJoan DalpeVincent BaumelBarry PlumAmy SchneiderErin EasterElissa FinkMarc RueterChristian ChabotRicky Coppola