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.
1. No, You can't perform SQL Queries in Front end where as You can define in script. 2. What you want to play with API's. Can you describe little more
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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.
Do you have any reference - What we are talking about?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
