Opened 4 years ago

Closed 4 years ago

#300 closed Defect (Fixed)

Queries with a Single Series Group By Issues

Reported by: Tong Zheng Owned by: Tong
Priority: Unknown Milestone: Unassigned
Component: View-App Version: 2.3
Severity: Unknown Keywords:
Cc: pleo84103@…, garth.braithwaite@…

Description (last modified by Garth Braithwaite)

There are 2 issues when doing any 2.3 query that has a series with a single value.

1) The total row shows double values. 2) The grid does not show the series.

Steps to repeat the issues: 1) Run this builder: http://ibis.health.utah.gov/query/builder/pop/PopMain/Count.html

2) Select Years: 2011 2012, 2013 3) Select Age Groups: 5-14 years 4) Display by Category: Year

Series: Age group

5) Submit

View the grid's overall total and lack of series column.

Issue does not show if you select more than one age group.

Attachments (1)

Serise.png (311.4 KB) - added by Tong Zheng 4 years ago.

Download all attachments as: .zip

Change History (4)

Changed 4 years ago by Tong Zheng

Attachment: Serise.png added

comment:1 Changed 4 years ago by Garth Braithwaite

Description: modified (diff)
Summary: GroupBy Series ProblemQueries with a Single Series Group By Issues
Type: UnknownDefect

comment:2 Changed 4 years ago by Garth Braithwaite

Garth Comments: A) The duplicate total row value has been fixed as of ~svn 9050.

B) The omission of the single value series from the grid: This can be updated to force all group bys to show in the grid. However, this should be debated as it is actually a feature. The reason single series or 3 dims with a single value is automatically removed is to allow the data to be mapped and charted. There is no value in a series grouping with a single value. It makes it so you can't map it and makes it so a pie chart can not be used and bar charts from displaying properly. When applied to 3d datasets that only have 1 value for a given group by it allows the grid to display properly and for the charts to work as well. Otherwise they would not work.

comment:3 Changed 4 years ago by Tong Zheng

Resolution: Fixed
Status: newclosed
Note: See TracTickets for help on using tickets.