How to count number of values in revision member from SVN commit report

I exported the commit history for an SVN repository, including revision numbers, file paths, datetime, and author. This file was converted to CSV, then imported to eazyBI, and given its own cube. The Revision column was imported as an integer measure.

The Revision member automatically adds the actual revision values rather than treating them as nominal values, but I need to display the number of commits per author per time period. 

Currently, I'm trying everything I can find to simply count the values in [Measures].[Revision] per [Time].CurrentHierarchy.DefaultMember to no avail.

I'm pretty new to eazyBI, but I have been going through the documentation webcasts. Any help is appreciated!

2 answers

1 accepted

Thanks to Ilze Leite-Apine from eazyBI support!

 

When imported as a measure, Revision number is treated as a numeric value, and, in eazyBI, all numeric values are summed up for totals.

Instead, I would suggest you add one column as a counter (1 for each row), and import that column as a measure: it would show the count of commits per day per person.
Revision column could be imported as a dimension if you do want to drill into the counter and find particular revisions. Commit messages could be imported as revision properties, and displayed when revisions are selected in rows. (See example below)

Important! Please delete existing SVN data cube before importing the modified source file because structural changes are needed!

eazybi_svn_mapping.PNGeazybi_svn_drill.PNG

Well, so far I am just faking it with this calculated member:

CASE
WHEN [Measures].[Revision] > 300000 THEN
  ([Measures].[Revision], [Author].CurrentHierarchyMember) / 200000
WHEN [Measures].[Revision] > 0 THEN
  1
ELSE
  NULL
END

This allows me to produce the chart I want, but it's just not 100% guaranteed accurate.

svn_commit_report.png

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

168 views 0 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you