David Jackson Posted April 22 Share Posted April 22 Hi, I am new to Hornbill so be gentle, I have managed to use Python to pull a report from Hornbill to be used in PoweBi, which is fine. I want to be able to compare year-to-year data. Unfortunately, I am unable to pull a full year's ticket data as the limit is 25k whereas for 2023 just under 33k were logged. So I am open to suggestions on how to get all the data from last year with the additions of what's been logged this year. I have a vision I will have to have a master sheet somewhere which has all the legacy information which I have to manually update every time I reach the limit, but like I said open to suggestions and ideas. Thanks Link to comment Share on other sites More sharing options...
Steve Giller Posted April 22 Share Posted April 22 The short version is: Pull 6 months' data, store this in a table locally, or even a spreadsheet. Pull the next 6 months' data, and then add that to the table/spreadsheet. 1 Link to comment Share on other sites More sharing options...
Gerry Posted April 22 Share Posted April 22 @David Jackson Basically exactly what @Steve Giller says, page the data out. If there is too much data for 6 months, try three, or one for each month of the year, consolidate the results in your working data sets. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now