cancel
Showing results for 
Search instead for 
Did you mean: 

Visual Composer chart question

john_coudriet
Participant
0 Kudos

I am new to visual composer and trying to create the following chart:

I have 3 queries returning data one query for orders, shipments and open orders. Each query returns 3 rows for the product groupings displaying in a table. So each table looks like:

Product Value

A V1

B V2

C V3

I then need 3 charts that has each of product's orders, shipments and open orders. I tried using a filter (to filter the product data) and combine operators, but it doesn't appear to work consistently. I also tried a data store, but that did not work either.

any help would be appreciated.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What are you trying to achieve?

Putting the data from the 3 queries in 3 charts?

Combining them into one chart?

Something else?

john_coudriet
Participant
0 Kudos

Mario

I am trying to create 3 charts one for A Products, B Product, C Products.

In each chart I would like to present the Sales, Shipments and Open Orders. I need on row of data from each query to be brought together in each chart.

Former Member
0 Kudos

That doesn't work. You need to build the query right so that it brings you the data in the form you want.

So in total for that model you'd need not 3 queries but 6 queries.

That also is performing better, as you shall avoid heavy filtering, sorting joining on the client = model side.

Answers (0)