etienne.girot Posted October 20, 2014 Posted October 20, 2014 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 idFavorite fruitAge1Apple362Apple143Banana564Apple51I use the "table" widget to get AVG(age)Apple33,7Banana56And I'd like to draw it this wayCan 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!
ernestoo Posted October 21, 2014 Posted October 21, 2014 Sure you can create a sub-dataset and attach it to both the table and the chart - I think the query will only run once
etienne.girot Posted October 21, 2014 Author Posted October 21, 2014 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?
ernestoo Posted October 21, 2014 Posted October 21, 2014 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!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now