Numbers are not grouping together

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.

Screen Shot 2017-01-23 at 4.19.07 PM.png

SELECT
(sales_amt/trans_count),

sales_amt,
.

.
begindate
FROM database
WHERE type = 'SERVICE FEES'

GROUP BY (sales_amt/trans_count) ;

Thank you

Taylor

Find more posts tagged with

Accepted answers

TDaily

What I did to get it to work was kind of like Aaron suggested, I used SQL to create a new output table and rounded the calculation to the closest 2 decimals and that solved the issue.

SELECT

ROUND(sales_amt/trans_count,2) as fee,

trans_count as Transactions,

FROM Database;

All comments

Do you have an aggregation of some kind in your SELECT statement? Like a SUM() or COUNT()?

TDaily

No I don't have any aggregations of any kind in my SELECT statement.

To get values to group together there would need to be an aggregation of some sort. Either on the SQL or on the table card. For example, you could sum the transaction column but not the amount column to get the number of transactions per transaction amount.

TDaily

Thnak you for your help and looking into my issue.

On the Domo side I am summing the transactions. So I have that aggregation. It is like Domo doesn't recongize that those two $5 numbers are the same. I was thinking it could possibly be slighlty different like 10 decial places. I don't know if that is what it is but I know with some computer calutaltions stuff like that can happen.

$5.00000000001

$5.00000000000

That's very possible. To test that, create a beast mode that just looks at the first two decimals. Try a ROUND() function.

TDaily

What I did to get it to work was kind of like Aaron suggested, I used SQL to create a new output table and rounded the calculation to the closest 2 decimals and that solved the issue.

SELECT

ROUND(sales_amt/trans_count,2) as fee,

trans_count as Transactions,

FROM Database;