Age grouped in metabase

marfilhofap · April 17, 2024, 7:45am

I made a table in the metabase about Age Groups, based on my dataset, the minimum age is 19 and the maximum is 90, but why does the table from my metabase of age groups start from 15 and end with 98? I tried changing the grouping, but it still doesn't start with the minimum age and ends with the maximum age.

Age average

TonyC · April 17, 2024, 11:39am

What version are you running? And can you share a screenshot of the GUI setup ... I think it should take the min and max which gets populated during fingerprint. maybe at the time of the scan you had 15 and 98 as min and max?

marfilhofap · April 18, 2024, 7:53am

I'm using Metabase version v0.48.0

As I explained previously, my dataset consists of Min age is 19 and Max age is 90. And I grouped it by selecting 10 groups. but the age results in the table range from 15 to 98.

TonyC · April 18, 2024, 8:41am

Try upgrading to 49.6 but to me those values make sense since the min and max you are specifying are part of the middle bin.

15+23/2 = 19

but then again there are some issues with binning for reference:

github.com/metabase/metabase

Binning not returning the correct amount of bins

opened 06:28PM - 27 Feb 20 UTC

flamber

Type:Bug Priority:P3 Querying/Processor Difficulty:Hard .Backend

**Describe the bug** Binning not returning the amount of bins selected. And can… even fail in "Auto". Simon said in the forum: > it might be more than one issue at play here **To Reproduce** Repro 1: 1. Simple question > Sample Dataset > Products 2. Summarize by Count. Group by Rating:10bins = returns 8 Group by Rating:50bins = returns 18 (of 23) Repro 2: 1. Create a Native question with this SQL (68 rows) and save the question as Q1 <details><summary>Show query</summary> ``` SELECT 0.500000 AS "Hours", 3 AS "Count", 0.500000 AS "Average of Hours" UNION ALL SELECT 1.000000 AS "Hours", 8 AS "Count", 1.000000 AS "Average of Hours" UNION ALL SELECT 1.500000 AS "Hours", 2 AS "Count", 1.500000 AS "Average of Hours" UNION ALL SELECT 1.716666 AS "Hours", 1 AS "Count", 1.716666 AS "Average of Hours" UNION ALL SELECT 1.833333 AS "Hours", 2 AS "Count", 1.833333 AS "Average of Hours" UNION ALL SELECT 2.000000 AS "Hours", 2 AS "Count", 2.000000 AS "Average of Hours" UNION ALL SELECT 2.166666 AS "Hours", 1 AS "Count", 2.166666 AS "Average of Hours" UNION ALL SELECT 2.500000 AS "Hours", 1 AS "Count", 2.500000 AS "Average of Hours" UNION ALL SELECT 2.550000 AS "Hours", 1 AS "Count", 2.550000 AS "Average of Hours" UNION ALL SELECT 3.000000 AS "Hours", 3 AS "Count", 3.000000 AS "Average of Hours" UNION ALL SELECT 3.166666 AS "Hours", 1 AS "Count", 3.166666 AS "Average of Hours" UNION ALL SELECT 3.250000 AS "Hours", 1 AS "Count", 3.250000 AS "Average of Hours" UNION ALL SELECT 3.500000 AS "Hours", 3 AS "Count", 3.500000 AS "Average of Hours" UNION ALL SELECT 3.516666 AS "Hours", 1 AS "Count", 3.516666 AS "Average of Hours" UNION ALL SELECT 3.750000 AS "Hours", 1 AS "Count", 3.750000 AS "Average of Hours" UNION ALL SELECT 3.966666 AS "Hours", 1 AS "Count", 3.966666 AS "Average of Hours" UNION ALL SELECT 4.000000 AS "Hours", 2 AS "Count", 4.000000 AS "Average of Hours" UNION ALL SELECT 4.166666 AS "Hours", 1 AS "Count", 4.166666 AS "Average of Hours" UNION ALL SELECT 4.500000 AS "Hours", 2 AS "Count", 4.500000 AS "Average of Hours" UNION ALL SELECT 4.650000 AS "Hours", 1 AS "Count", 4.650000 AS "Average of Hours" UNION ALL SELECT 4.783333 AS "Hours", 1 AS "Count", 4.783333 AS "Average of Hours" UNION ALL SELECT 4.900000 AS "Hours", 1 AS "Count", 4.900000 AS "Average of Hours" UNION ALL SELECT 5.000000 AS "Hours", 4 AS "Count", 5.000000 AS "Average of Hours" UNION ALL SELECT 5.083333 AS "Hours", 1 AS "Count", 5.083333 AS "Average of Hours" UNION ALL SELECT 5.250000 AS "Hours", 1 AS "Count", 5.250000 AS "Average of Hours" UNION ALL SELECT 5.283333 AS "Hours", 1 AS "Count", 5.283333 AS "Average of Hours" UNION ALL SELECT 5.950000 AS "Hours", 1 AS "Count", 5.950000 AS "Average of Hours" UNION ALL SELECT 6.000000 AS "Hours", 1 AS "Count", 6.000000 AS "Average of Hours" UNION ALL SELECT 6.666666 AS "Hours", 1 AS "Count", 6.666666 AS "Average of Hours" UNION ALL SELECT 6.833333 AS "Hours", 1 AS "Count", 6.833333 AS "Average of Hours" UNION ALL SELECT 6.850000 AS "Hours", 1 AS "Count", 6.850000 AS "Average of Hours" UNION ALL SELECT 6.983333 AS "Hours", 1 AS "Count", 6.983333 AS "Average of Hours" UNION ALL SELECT 7.000000 AS "Hours", 2 AS "Count", 7.000000 AS "Average of Hours" UNION ALL SELECT 7.266666 AS "Hours", 1 AS "Count", 7.266666 AS "Average of Hours" UNION ALL SELECT 7.500000 AS "Hours", 1 AS "Count", 7.500000 AS "Average of Hours" UNION ALL SELECT 8.000000 AS "Hours", 1 AS "Count", 8.000000 AS "Average of Hours" UNION ALL SELECT 9.166666 AS "Hours", 1 AS "Count", 9.166666 AS "Average of Hours" UNION ALL SELECT 10.300000 AS "Hours", 1 AS "Count", 10.300000 AS "Average of Hours" UNION ALL SELECT 10.366666 AS "Hours", 1 AS "Count", 10.366666 AS "Average of Hours" UNION ALL SELECT 10.500000 AS "Hours", 1 AS "Count", 10.500000 AS "Average of Hours" UNION ALL SELECT 10.866666 AS "Hours", 1 AS "Count", 10.866666 AS "Average of Hours" UNION ALL SELECT 11.616666 AS "Hours", 1 AS "Count", 11.616666 AS "Average of Hours" UNION ALL SELECT 11.750000 AS "Hours", 1 AS "Count", 11.750000 AS "Average of Hours" UNION ALL SELECT 12.000000 AS "Hours", 1 AS "Count", 12.000000 AS "Average of Hours" UNION ALL SELECT 13.200000 AS "Hours", 1 AS "Count", 13.200000 AS "Average of Hours" UNION ALL SELECT 14.000000 AS "Hours", 1 AS "Count", 14.000000 AS "Average of Hours" UNION ALL SELECT 14.266666 AS "Hours", 1 AS "Count", 14.266666 AS "Average of Hours" UNION ALL SELECT 14.683333 AS "Hours", 1 AS "Count", 14.683333 AS "Average of Hours" UNION ALL SELECT 14.700000 AS "Hours", 1 AS "Count", 14.700000 AS "Average of Hours" UNION ALL SELECT 14.983333 AS "Hours", 1 AS "Count", 14.983333 AS "Average of Hours" UNION ALL SELECT 15.400000 AS "Hours", 1 AS "Count", 15.400000 AS "Average of Hours" UNION ALL SELECT 15.416666 AS "Hours", 1 AS "Count", 15.416666 AS "Average of Hours" UNION ALL SELECT 16.850000 AS "Hours", 1 AS "Count", 16.850000 AS "Average of Hours" UNION ALL SELECT 17.116666 AS "Hours", 1 AS "Count", 17.116666 AS "Average of Hours" UNION ALL SELECT 18.683333 AS "Hours", 1 AS "Count", 18.683333 AS "Average of Hours" UNION ALL SELECT 19.333333 AS "Hours", 1 AS "Count", 19.333333 AS "Average of Hours" UNION ALL SELECT 19.833333 AS "Hours", 1 AS "Count", 19.833333 AS "Average of Hours" UNION ALL SELECT 19.916666 AS "Hours", 1 AS "Count", 19.916666 AS "Average of Hours" UNION ALL SELECT 20.233333 AS "Hours", 1 AS "Count", 20.233333 AS "Average of Hours" UNION ALL SELECT 23.050000 AS "Hours", 1 AS "Count", 23.050000 AS "Average of Hours" UNION ALL SELECT 23.500000 AS "Hours", 1 AS "Count", 23.500000 AS "Average of Hours" UNION ALL SELECT 23.933333 AS "Hours", 1 AS "Count", 23.933333 AS "Average of Hours" UNION ALL SELECT 26.100000 AS "Hours", 1 AS "Count", 26.100000 AS "Average of Hours" UNION ALL SELECT 27.766666 AS "Hours", 1 AS "Count", 27.766666 AS "Average of Hours" UNION ALL SELECT 29.250000 AS "Hours", 1 AS "Count", 29.250000 AS "Average of Hours" UNION ALL SELECT 33.016666 AS "Hours", 1 AS "Count", 33.016666 AS "Average of Hours" UNION ALL SELECT 37.050000 AS "Hours", 1 AS "Count", 37.050000 AS "Average of Hours" UNION ALL SELECT 77.750000 AS "Hours", 1 AS "Count", 77.750000 AS "Average of Hours" ``` </details> 2. Simple question > Saved Questions > Q1 3. Summarize by Count, Average of "Average of Hours" 4. A. Group by Hours:10bins - returns 5 bins B. Group by Hours:100bins - returns 28 bins (of 68) **Screenshots** If applicable, add screenshots to help explain your problem. ![image](https://user-images.githubusercontent.com/1447303/75472714-335d3600-5994-11ea-8f2a-6f090b1bbeb2.png) **Information about your Metabase Installation:** Metabase 0.34.1 and `master`, various setups and backends. **Additional context** https://discourse.metabase.com/t/histogram-bin-size-not-working-well/9066 Very likely related to #9321 :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment