topic Selection within a graph in Water Cooler

Selection within a graph

Mon, 16 Apr 2012 16:13:20 GMT

Hello !

I have a Stack Bar Graph where I need to filter some data before counting it.

When I do this selection manually, the graph is shown correctly.

However, I need the graph to consider those selections independently, regardless of the current selection.

The attached QVW contains the selection (it is selected already), as well as the graph and the data.

ThanXs !

Re: Selection within a graph

Jason_Michaelides — Mon, 16 Apr 2012 16:28:26 GMT

Hi,

THis is very simple using set analysis. I saved your current selections into a bookmark, then instead of:

=COUNT(CODMOV_BBMOV)

use:

=COUNT({BM01} CODMOV_BBMOV)

Hope this helps,

Jason

Selection within a graph

Mon, 16 Apr 2012 17:08:05 GMT

Thank you !

Very simple indeed.

Wish we had a "mini tutorial" about set analysis, with several examples and so forth...

But thanks anyway !

Re: Selection within a graph

Jason_Michaelides — Mon, 16 Apr 2012 17:09:13 GMT

There's LOADS of stuff on this forum, but before that the F1 help is actually pretty good...there's even a Set Analysis builder app online somewhere,,,

Re: Selection within a graph

Jason_Michaelides — Mon, 16 Apr 2012 17:10:11 GMT

By the way - if an answer given is correct, please mark it as such so others can see in search results that it's been answered.

Cheers,

Jason

Re: Selection within a graph

Mon, 16 Apr 2012 17:31:18 GMT

Another issue...

Say that the Graph is based on a Set Analysis of invoices that are delayed (not paid until today). We can then make the selection , freeze it on a BookMark and build the graph upon it.

So far so good.

However, let's say that now the end user wants to see the invoices PER STORE. That is, he/she wants to refine the selection.

In this case Set Analysis doesn't seem to work...

Or would there be another detail ?