ContributionsMost RecentMost LikesSolutionsNumber of days in a given monthHi 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 isrelated to another table with the device ID, friendly name, contact and other info. Any help is much appreciated!! -pete ------------------------------ Pete MacKenzie ------------------------------ Re: table to table import too longAll right, got 'em all now....was an issue of in correctly specific one of the fields as unique....when it wasn't. This wasn't showing the correct error until I limited the import to just the last weeks of data. Case closed....thanks all!! ------------------------------ Pete MacKenzie ------------------------------ Re: table to table import too longHi Mark, New to the community here and was told by my coworker Ryan that you'd be the first to respond :-) ! We are manually hitting the import. We have been successful with many other sync'd table to table imports. Just not sure why we're having difficulty with this one. thanks much! -pete ------------------------------ Pete MacKenzie ------------------------------ table to table import too longHi All, Trying to import from sync'd table into local table using a table-to-table import. The source sync table has 68,000 records, and only about 24 fields. Request URL Too Long HTTP Error 414. The request URL is too long. Any ideas ? thank you, -pete ------------------------------ Pete MacKenzie ------------------------------