How can I get Statistical Calcualtions on data from FogBugz? For example, how do I get the average time spent by a developer on solving bugs of priority-2 during last one month.
|
1
|
|
|
|
|
1
|
While our Reporting plugin is pretty great at viewing historical data, it doesn't have the capability of doing statistical analysis like this. When we find ourselves needing (or just wanting) to get more data out of FogBugz, we pull the raw data out of the XML API and then do the analysis ourselves. In the case you provided, you would want the XML to do a search along the lines of:
That filter isn't perfect for what you want, but should give you a good starting place. For instance, if someone else had added time to one of those cases, it would include that. It also includes cases which he resolved in the last month, regardless of when he actually worked on them. Those problems can certainly be resolved with some tweaking, however. Alternative to the XML API, you can also export a filter to Excel, if you don't want to write a tool to do the analysis for you. Just install the Filter Export plugin, create a filter in FogBugz, then click the "More" menu in the upper-right corner of the List Cases page. If you're having trouble getting the right data out of FogBugz, please contact us directly! |
||
|
|
