6 Replies Latest reply on Apr 27, 2016 8:10 AM by chieko.seto

    How to compare latest 2 days result?

    chieko.seto

      I want to show an arrow on a dashboard  such that  if the most latest day's total admission  is greater than the second latest day's total  admission then green color up arrow will  be appeared, otherwise red color down arrow.

      Data is refreshed daily,  I would like to create a calculated filed that calculates the difference only between the latest day's total admission and the second latest day's total admission but I can't find the way to pull only those 2 day's daily total.

      Could somebody please give me the solution of this problem?    I would appreciate any advice and tip..

       

      Thank you,

      Chieko