Adding a new column to the data selection

Get Help
1

Hello
How can I add one column with ranking function to the table selection in query builder?

image
image2074×1110 71.1 KB

(this one, not the SQL editor)

I joined 2 tables by time period as a key, and now I need to rank every string in final table (final selection), but I can`t add new column by using the interface. I need to copy the received SQL query,

image
image2566×1070 160 KB

(like this)

open SQL editor for a new query, paste my received query and manually add new column with the required function - ranking.

How can I do that without the SQL editor and manual typing sql functions?

2

There is no RANK option currently in the GUI editor. The only window function currently supported is offset:

3

Maybe I can add a custom column with a SQL query in it via the gui editor somehow? If Ill add it, Ill be able to write SQL ranking condition for it. It`s part of the query after all.

4

You can write anything in SQL

5

It needs to be done in the editor, cause in the future this function will be used by employees, who dont know SQL, and thats the main problem.

6

But there is no option for that in the editor right now