Hi everyone,
I'd like to know whether it is possible to reuse the values of a table as input to draw a bar char?
For example I get the following tuples from a dataset "SELECT * FROM User":
| User id | Favorite fruit | Age |
|---|---|---|
| 1 | Apple | 36 |
| 2 | Apple | 14 |
| 3 | Banana | 56 |
| 4 | Apple | 51 |
I use the "table" widget to get
| AVG(age) | |
|---|---|
| Apple | 33,7 |
| Banana | 56 |
And I'd like to draw it this way
.png)
Can I reuse the table data or should I change my dataset ?
Obviously, this is a huge simplification of what I need to do to make it understadable... The point is, I have to perform difficult crosstab calculations on a complex dataset query and draw them into a graph and it would same me a huge amount of time and headaches to use the capabilities of crosstab widget instead of writing them myself in SQL.
Thank you for your help!
As mentioned, the example above is a simplification, actually it is really difficult for me to obtain the 2nd table as a SQL query (which I think you would consider to be the sub-dataset). On the other side, the crosstab does it really easily, that's why I would like to use the crosstab output as input for a bar chart. Is it possible?
ah ok - if that's the case unfortunately the answer is no - I don't think you can export the totals into variables either...I am not 100% sure about this answer!