Is there a way to draw a straight table directly using SQL-like statements? I understand that there is a data load script that can be used (which is very useful), but for me it lacks one important feature. The table generated loses its relationship with other tables, so it is not affected by any filters applied. I think this is the nature of data load scripts. I am also familiar with aggr() function, but I think it complicates the logic.
Suppose that I have already a drawn straight table or any chart item. Is there a way that I can manipulate the data presented using JS for example (APIs)? i.e. I get the data in, let’s say, JSON format and then manipulate it and then draw it again? Of course by doing this I expect that the data lose its relationships with others, which is totally acceptable.
So suppose that I have a straight table. Since I cannot use SQL to reach the results I want, I am okay to take another approach such that I manipulate the data using a programming language. For example, I can introduce a new hierarchy levels and aggregate the values based on some conditions and then draw a pivot table, transpose, or transfer the table. Basically I am free to get data in a special format and then produce it again with the same format.