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.