Hello,

I would like to know if it is possible to have sum of HH:MM:SS time format in redash chart application and show it on Y-axis of chart (as metrics and not as dimensions). Currently I am using another web development tool where this calculation (Sum) for HH:MM:SS is not possible due to datatype ‘Time’. I am looking for alternative and hence would like to know if it is possible in Redash.
Any help will be appreciated.

Best Regards

Hello,

Can anyone please answer this thread, if it is possible or not. We are looking for the solution on priority basis.

Best Regards

Hi there and welcome to the forum. I’m going through some older threads.

To answer your question: it depends on your database. Redash doesn’t aggregate data. You should use your database to do that. Then tell Redash to show the aggregated field as text. I’m not sure how well our formatter will work for summed times greater than 23:59:59.

Check your database docs for date/time aggregation functions.