-
Suggestion
-
Resolution: Unresolved
Problem Definition
As described in FishEye reports, FishEye currently supports report function based on lines of code but doesn't support the one based on numbers of changed files.
Suggested Solution
It would be nice if FishEye support report function based on numbers of changed files.
The customer assumed a chart like...
- X-Axis : Time (Day, Week, Month)
- Y-Axis : Number of files that were modified in a given period (In case the files are changed multiple times in the period, it should be counted once)
Possible workaround
We can get the similar information with using EyeQL and download it as a CSV.
EyeQL query
To get the number of files that were changed (added, modified and deleted) on each day, use the following EyeQL query
select revisions from dir "/" where date >= 2016-01-01 and date < 2017-01-01 order by date group by month return count(distinct path), month
adjusting the dir and date parameters according to needs. To get a per day report, change "month" to "day" in the query.
h5. Example results
[FE-6810] Create report based on numbers of changed files
As EyeQL can be tricky to someone not used to it, I provided a query that returns the data your customer asked for: number of files changed per day/month. Weekly aggregation is not possible.
Kamil
I confirmed with the customer that their demand is as I put in the previous comment.
I updated the description.
Cheers,
Yuki
Thanks for your heads up.
Could you please elaborate? Do you mean the number of files that were modified in a given period?
Yes.
If a file was changed a few times, would you have it counted once, or multiple times?
I think that the original customer who wants this function assumes the first one. "it counted once"
However, let me double check it with the customer for sure.
Cheers,
Yuki
It is not clear what you mean by "report based on numbers of changed files". Could you please elaborate? Do you mean the number of files that were modified in a given period? If a file was changed a few times, would you have it counted once, or multiple times?
I'm asking, because I might be able to help you create a report using EyeQL.
Kamil
Hi everyone,
We have recently reviewed this issue and the overall interest in the problem. As the issue hasn't collect votes, watchers, comments, or support cases from many customers during its lifetime, it's very low on our priority list, and will not be fixed in the foreseeable future. That's why we've decided to resolve it as Not Being Considered.
Although we're aware the issue is still important to those of you who were involved in the conversations around it, we want to be clear in managing your expectations. The Fisheye&Crucible team is focusing on issues that have broad impact and high value, reflected by the number of comments, votes, support cases, and customers interested. Please consult the Implementation of New Features Policy for more details.
We understand how disappointing this decision may be, but we hope you'll appreciate our transparent approach and communication. Atlassian will continue to watch this issue for further updates, so please feel free to share your thoughts in the comments.
Kind regards
Marek Parfianowicz
Development Team Lead