Sum of values over grouped columns

[Benjamin S]

Hello,

I am currently struggling to achieve the same type of information as I do in a python script but directly in Tibco and I dont know where to start.

 

My table looks like this:

 

ExampleTable

 

 

Date

V1

V2

V3

 

 

 

 

...

"D"

1

"X"

 

 

...

"A"

2

"X"

 

 

...

"D"

3

"X"

 

 

...

"D"

2

"Y"

 

 

...

"A"

2

"Y"

 

 

...

"D"

1

 

"Y"

 

 

 

 

What I want to achieve now is something like this:

 

Filter for V1="D"

Group by V3

Sum V2 of each group

Bar plot with bars for X and for Y

 

I tried something like ([V1]="D") group by [V3]

but this is the point where i get lost

 

I would be thankful if somebody could help me here.

Cheers

[Kevin Flynn]

I couldn't really understand the question. But I assume you want to Sum up all the D's together, and A's together.

If that is the case you can use an OVER function and so something like Sum([V2]) over [V1]