I am trying to make a chart using different sale data. Currently I have an issue of certain numbers not grouping together. I have attached a picture to show what I am talking about. I have tried using the SQL tool to group the data together but I cannot get that to work. I have posted my SQL code below as well. Any ideas or help would be awesome.

SELECT
(sales_amt/trans_count),
sales_amt,
.
.
.
.
begindate
FROM database
WHERE type = 'SERVICE FEES'
GROUP BY (sales_amt/trans_count) ;
Thank you
Taylor