Xcelsius - Duplicate columns on the chart

other Xcelsius - Crystal Dashboard Design
1

Hi Everyone,
My QAAWS,s results is result 4 columns as follow:
col1 col2 col3 col4
a a1 x1 100
a a1 x2 80
a a2 x2 110
b b1 y1 230
b b1 y1 10
b b2 y2 20

I need to show the col1, col3 and col 4 on the column chart, but without duplicated values (grouping).
a x1 100
a x2 190
b y1 240
b y2 20
Please help me, How can I solve it? :hb:

joaoac (BOB member since 2009-06-03)

2

use a dsum function on the block of your data that qaaws returns for each value you want to chart.

sumif is another function that is useful, but not quite as good as dsum

Cairmor :us: (BOB member since 2008-06-05)

3

tks Cairmor, but I need aggregate values with more than 2 columns and after show these values in the chart.
I’m using qwaas to select data (not fix data) and when using the xcelsius filter the X label show duplicate data.

joaoac (BOB member since 2009-06-03)

4

Hi,
look at my sample.
If you have any questions just let me know.

Hope this helps,

solutionforumtopics.zip (2.0 KB)

Luca Spinelli :it: (BOB member since 2008-08-27)