Discussions

 View Only

Number of days in a given month

  • 1.  Number of days in a given month

    Posted 08-02-2021 17:57
    Hi All,

    I'm working on an uptime report for some devices. Each device checks in everyday. I'd like to show the percentage of check-ins per week and month per device.

    Monthly report:
    Device A checks in everyday of the month of July ( 31 checks ins), it'll shows 100% check in success.
    Device B checks in only 10 times during the month of July is will show 32% check in success.

    Would also like to have a weekly report:
    Device C checks in once during the week it received a 14% success
    Device D checks in five times during the week it receives a 71% success

    Right now i've a table with everyday that the device checked in and that is related to another table with the device ID, friendly name, contact and other info.

    Any help is much appreciated!!

    -pete

    ------------------------------
    Pete MacKenzie
    ------------------------------