chart sort by login attempt asc

1 files changed, 1 insertions, 1 deletions

diff --git a/src/db_handler.py b/src/db_handler.py
index 1c271d6..7ba74f8 100644
--- a/src/db_handler.py
+++ b/src/db_handler.py
@@ -64,7 +64,7 @@ SELECT count(la.id) as total_count, date_trunc('hour', la.timestamp) as date, cn
 FROM login_attempt la
 JOIN connection cn on cn.id = la.connection
 GROUP BY date_trunc('hour', la.timestamp), cn.ip
-ORDER BY date_trunc('hour', la.timestamp) DESC;
+ORDER BY COUNT(la.id)
 ;
                 """)
             histogram = cur.fetchall()