I have to find top x problems (by day, week or month) in clickhouse table.
My idea is to create a python script that will collect the data, find linear regression coefficients, sort them descending, and return top x?
That python script can be behind some mini web server like bottle, or flask.
So from redash I should get the parametar for time intervals (day/week/month), send that parametar to python script behind web server. Python script should return, problem id’s, and than redash should collect all data with these problem id’s in order to show the trend graph.
Is that type of interaction between python script, web server and redash possible?