From e4b6729597aa59df551ab469d909e58713dee625 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 24 Aug 2020 12:10:14 -0400 Subject: [PATCH] LP#1789679: add illustrative example to release notes Signed-off-by: Galen Charlton --- docs/RELEASE_NOTES_NEXT/Reports/report_subtotals.adoc | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/docs/RELEASE_NOTES_NEXT/Reports/report_subtotals.adoc b/docs/RELEASE_NOTES_NEXT/Reports/report_subtotals.adoc index bf70f6e75b..57032e6ae2 100644 --- a/docs/RELEASE_NOTES_NEXT/Reports/report_subtotals.adoc +++ b/docs/RELEASE_NOTES_NEXT/Reports/report_subtotals.adoc @@ -9,3 +9,15 @@ This takes advantage of PostreSQL's built-in ROLLUP feature. See the PostgreSQL documentation for details: https://www.postgresql.org/docs/9.6/queries-table-expressions.html#QUERIES-GROUPING-SETS + +An example of a report that could use this new feature is +one based on the Circulation source with the following fields: + + * Circulation -> Checkout / Renewal Library -> Short (Policy) Name (Raw Data) + * Circulation -> Checkout Date/Time (Year) + * Circulation -> Shelving Location -> Name (Raw Data) + * Circulation -> Circ ID (Count Distinct) + +Turning on the "Calculate grouping subtotals" checkbox would make +the report show subtotals for each combination of +short name, checkout year, and shelving location name. -- 2.11.0