on 06-19-2007 4:55 PM
Hi,
is it poosible to use 2 different queries as input for one chart view.
How can I use this function ?
I need one data series from query1 and one data serie from query2.
It is not poosible to build one bi-query with the right data.
Have anybode an idea ?
Thanks
Best regards
thomas
Hi Thomas
The best way to achieve this is to write a procedure(or query) by joining the two tables to get the desired columns/data in one hit and then plot it on the chart.
Regards
Navneet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of simply connecting the DataService and Chart , write a SQL query using JOINS in SQL Statement. Then you can have columns of both TABLES in your chart and you can have the data series as desired.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
you can't do this in the Visual Composer at the moment, because a chart can have only 1 Input and the combine operator can't be use for data series.
The only way to combine queries will be in the backend system
Regards
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.