8 Replies Latest reply: Jul 31, 2015 12:55 PM by Sunny Talwar RSS

    Gauge of todays data

      HI there

       

      Hope you are all well?

       

      I have data that basically is a historic record of total orders vs invoiced orders, as such

       

      date               qty_ord     qty_inv

      01/07/2015     100          100

      02/07/2015     100          90

       

      and so on,

       

      I want to create a multi guage screen that shows the fullfilment % ( qty_inv / qty_ord) for today, this week and this month however I can't seem to wrap my head around how to isolate just todays/this weeks data in the gauge.

       

      Thanks in advance.

       

      Chris