selected value in data Island and dimensions in graph

[#1]

Hello,

The requirement is to filter on 2 facts based on single value selection.So I have used a list box to fill in data with data island.

I am grouping based on selected value in data island on a graph and using some triggers and set analysis in expressions.

When only 1 value is selected in data island, the graph is perfect.

But when multiple values are selected, it is summing up the result as below:

How to avoid this.

Thanks,

Deepa

[#2]

post your sample application for more clarification of your requirement.

[#3]

PFA the sample...

[SunilChauhan]

ther is no link between date and TrackingHardCoating and TrackingQuantity

and inpace of sum you need to count for TrackingHardCoating , as these seems as ID's and sum(TrackingQuantity)

hope this helps

[#5]

Hi Sunil,

Thanks for the reply,

Since the idea is to consider TrackingHardCoating for blue part (launched) and TrackingBreakage for red part (rejected) part of the graph, I used data Island.

The linking is been done using triggers

on Selection of TEMPDATE, I am setting a variable and using that in Set Analysis expression.

and Infact, it is not always 'HardCoating', it can be any value in 'Processed Workshop'. The column changes accordingly, for this there is another trigger on selection of 'Processed Workshop' to set vOperation

Sum(TrackingQuanity) or count(TrackingID) both should give the same result.

Thanks,

Deepa V