Jump to content

Recommended Posts

Posted

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 fruitAge
1Apple36
2Apple14
3Banana56
4Apple51

I use the "table" widget to get

 AVG(age)
Apple33,7
Banana56

And I'd like to draw it this way

Sanstitre(3).png.c1f7bd4bee6782f116f0a4c874256ce8.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!

 

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Posted
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?

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...