Custom Reports

[chadillac]

if someone (myself) were to build a third party admin panel strictly made for custom reporting of stored Kayako data, would there be enough demand within the Kayako community to deseminate it out to other Kayako users?


basically, if you could have a set bunch of custom third party reports that handled Kayako data, would you be interested in it?

E.G. Conversion time from status "New" to status "Order Placed" per Staff Member in Department "Sales"


Thanks;
Chad

[tommy]

Hi Chad,

I would be interested in custom report capabilities!

[kaviar]

I'd be interested in this

[netarus]

Hi chadillac,

I am very interested as well. Feel free to start with mine if it is any help at all.

http://www.netarus.com/products/show...esupportreport

Either way, I would love to find a solution to the lack of reports for eSupport.

[kaviar]

Hi,

Will that script work with supportsuite?

[eljustino]

HI Chad,

I think this is definately something people will be interested in.

Kayako were looking at a Reports API but I haven't heard much of this.

You can see some of the feedback on reports here: http://forums.kayako.com/showthread.php?t=3901

[ehoffman]

I would certainly get on board, free or not.

[chadillac]

nice script netarus... thats similiar to what I'm working on, but at the moment I'm just perfecting the SQL queries, no interface yet... but I like yours thus far

[netarus]

Hi chadillac,

Care to share the SQL queries and I can help inserting them into the existing report?

[chadillac]

just getting started on them, handful of other projects consuming most of my time... I plan on jumping in head first over the next couple days

[chadillac]

sneak peek of an example report:


this report calculates average response time per user for all tickets with a closed status or something considered a closed status (this is company specific for us at the moment)

its just a baby and I plan on a lot of building in the near future... but for now, the project is on hold for a few days.


http://cableorganizer.com/kayako_reports/

[Adam12]

Originally Posted by chadillac

sneak peek of an example report:


this report calculates average response time per user for all tickets with a closed status or something considered a closed status (this is company specific for us at the moment)

its just a baby and I plan on a lot of building in the near future... but for now, the project is on hold for a few days.


http://cableorganizer.com/kayako_reports/

Hey do you think you can share that with us?

[netarus]

If chadillac sends me his SQL statements, I could integrate it into a new drop down option within my reports based on selecting a particular user.

Best Regards,

Chris

[chadillac]

Average Response Time Query:

SELECT AVG(TIMEDIFF(from_unixtime(lastactivity),from_unix time(dateline))) as TimeDifference FROM swtickets WHERE ownerstaffid = $user AND ticketstatusid = 3;


++++++++ NOTE +++++++++++++

In order for this to work you have to tweak your kayako functions to update last activity on ticket status change Also this only calculates deafult "closed" status, other custom statuses aren't included in this yet, I plan on making a seperate database of my own that will house "Closed" statuses out of all statuses with a nice UI, then it will inject those into the query.

[netarus]

What about the queries for the other two fields?