LiquidPlanner Classic Forum

*Posted on behalf of Bryan deSilva. Original posting date 2017-03-24* So with Nadia's help I am now able to pull my Analytics report data into Excel. Cool. But that only shows the current month that the report can handle. I want all my data for each month coming over. In the analytics report I cannot choose to show all my data except already totaled. I need the pay$ and billable$ BY month for many months. Suggestions?

*Posted on behalf of Bryan deSilva. Original posting date 2017-03-23.* I cannot use a pivot table. Everything is zero. Even if I format it manually. What's up with this? I'm using query in Excel using the API address as instructed in the API guide. The data comes, but isn't usable. What might I be doing wrong? I can manually add two numbers (=A1+B1), but I cannot =SUM(....) nor create a pivot table. Just zeros.

*Posted on behalf of a customer. Original posting date 2016-04-12.* Greetings, we are manually feeding data into Microsoft's Power BI (MS Tableau basically) via timesheet export to enable the attached image. In speaking with my main contact there, his assessment of what data would be necessary to provide a similar view of future work would be: hours per person, per day, per project. To this end, my questions are: 1. Is this possible via API? 2. Is there a different data set (aside from the one in the title) that would accomplish the same result...perhaps more easily? 3. Any detail as to what calls they might need to make, (in case that's not terribly complex and handled more efficiently in a live discussion, etc.) Please let me know if I can offer any clarification. Thanks!

*Posted on behalf of mstearne. Original posting date 2015-03-15.* I am looking to retrieve a fully formed dashboard in order to email it on a schedule. Do dashboards that are created exist yet in the LP API? I don't believe it is in the API yet but I was wondering if the data is available.

*Posted on behalf of Matt Bromwich. Original posting date 2015-01-08.* I would like to retrieve the "Hrs remaining" for a project for only a specific date range (e.g. the estimated effort required for a project during week 3). For example "project X" has tasks spanning several weeks (say week 2, week 3 and week 4). I would like to retrieve the estimated work for each of the weeks. This data can be accessed (manually) in Analytics using a project rollup reported filtered by custom dates. Can this same data be retrieved using the API? If a method exists it would also be useful for looking at effort/week for individual tasks and for individual resources as well.

*Posted on behalf of a customer. Original posting date 2014-12-10.* I’m currently trying to retrieve the raw data for a resource report (person roll-up) through the api. When I query timesheets I do not get a connection to a task though so I can’t get the data I need. What we are trying to do is feed that data to geckoboard to get a dashboard of graphs for specific reports we are running. Any help?

*Posted on behalf of Brian. Original posting date 2013-08-28* Is it possible to download a report that I have saved on my Analytics tab via the API? We use those reports for invoicing clients every month, and I'm looking to automate the download process. Thanks, Brian

*Posted on behalf of David Conde Marin. Original posting date 2012-12-02.* Hi I need to recover the files generated by reports previously existing in my workspace. I don't need to create the actual reports using the API, just recover which reports are currently on the system and retrieve the csv file generated by one of them. Many thanks, David