search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

New count operation for summarization #579

Closed Seddryck closed 4 years ago

Seddryck commented 4 years ago

It would be interesting to have a count operation returning how many rows are in each group created by the group operation.

<summarize>
  <count />
  <group-by>
    <column identifier="fruit"/>
    <column identifier="supplier"/>
  </group-by>
</summarize>

At the opposite of other operations, count is not expecting a column identifier because this operation relies on the whole row and not on a specific column.

Seddryck commented 4 years ago

As a workaround, you can extend with a new column setting a value of 1 for all the rows and summarize with a sum on this column.

Seddryck commented 4 years ago

Beta available at https://ci.appveyor.com/project/Seddryck/nbi/builds/30628245/artifacts or 1.23.0-beta.4