You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Recently, the dashboard shows a top row of statistics, a large blank area below that line, on the left, and the calendar on the right. Is this an error with my setup or a change in the UI?
Edit: Turns out it is a divide by zero error on my end. When the web app was trying to run the query below, it was getting a "Divide by Zero" error. SELECT workouts.id as id,max(total_distance / ((total_duration - pause_duration) / 1000000000)) as value,workouts.date as date FROM "workouts" join map_data on workouts.id = map_data.workout_id WHERE user_id = 1 AND type = 'walking' GROUP BY "workouts"."id" ORDER BY max(total_distance / ((total_duration - pause_duration) / 1000000000)) DESC LIMIT 1
This is the offending part of the calculation and where I found the error. total_duration - pause_duration
All Good now.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Recently, the dashboard shows a top row of statistics, a large blank area below that line, on the left, and the calendar on the right. Is this an error with my setup or a change in the UI?
Edit: Turns out it is a divide by zero error on my end. When the web app was trying to run the query below, it was getting a "Divide by Zero" error.
SELECT workouts.id as id,max(total_distance / ((total_duration - pause_duration) / 1000000000)) as value,workouts.date as date FROM "workouts" join map_data on workouts.id = map_data.workout_id WHERE user_id = 1 AND type = 'walking' GROUP BY "workouts"."id" ORDER BY max(total_distance / ((total_duration - pause_duration) / 1000000000)) DESC LIMIT 1
This is the offending part of the calculation and where I found the error.
total_duration - pause_duration
All Good now.
Beta Was this translation helpful? Give feedback.
All reactions