Unfortunately, you cannot use the Y axis drop down to control to show a subset of data. However, if you wish to show different data in two different Graph views on the same tab then you will have to use "Named Queries". Using Named Queries you can create different snapshots of data and assign a query to a particular view. If you want to show different snapshots for different Y axis fields then you will have to create additional views in conjunction with Named Queries. Another alternative is to use tabs instead of Named Queries.

If the above doesn't solve the exact problem you are experiencing then can you post a sample file together with more information as to what exactly you are trying to achieve.

Attached is an example file with 3 graph views, each one with a query as data subset, in order to handle different data in every graph views.

Regards

Hi Antonio,

Unfortunatelty that solution isn't going to work for me. I have three types of data for example and then 10 different metrics under each type. I wanted to be able to have a graph view for each type of data (3 graph views) and then the 10 metrics on the y axis sitting within each type. seperate tabs for each wiln not work either as i already have multiple tabs and this will be going out to a client. Why isn't it possible to do what I'm asking if it's possible to do this on seperate tabs?

Any other ways around this that you can think of?

I have had similar requirement before, and one of the ways I have solved this is to use a custom variable who values are the names of the metrics.

Then I added a function field called metric, that has the following function:

IF([customvar] = "Metric 1", [Metric 1],
[customvar] = "Metric 2", [Metric 2],
...
...
)

I then use this formula field as the Y-axis ion the graph.

So when I selected a sepcific metric name for the variable, immediately the values change and subsequently the graphs.

I hope this helps.

Cheers!
Indranil