Set Analysis

[#1]

Hi

I need a little help with set analysis.

I have a stacked Bar Graph with 2 expressions:

1) Total Hours Logged for Transactional Work - Colour blue

2) Total Hours Logged for Non-transactional Work - Colour Red

All my data has a field called TransactionType that indicates if a transaction is 'Transaction' or 'NonTransaction'

I am using set analysis in the bar graph to select the relevant transactions for each expression.

sum({$<TransactionType={'Transaction'}>}TimeSpentOnTask}

and

sum({$<TransactionType={'NonTransaction'}>}TimeSpentOntask}

this all works fine, however if I add a listbox to the sheet with transaction type and then select 'NonTransaction' the numbers reduce but I still see both expressions and hence both bars in the stack. I would have though the 'Transaction' bar would disappear from the graph as it has been eliminated by the current selection???

Thanks

JP

[#2]

hi,

it`s like correct, can you attach an example.

[chematos]

Hi,

In the expressions menu you have a Conditional option, so you could use this:

TimeSpentOnTask = 'Transaction'

and

TimeSpentOnTask = 'NonTransaction'

each one for each expression.

Hope this helps

[#4 · Accepted solution]

Hi Jose

Not exactly correct but all I needed to figure out the correct answer, thanks a mil.

correct answer:

Apply the conditional filter and set the filter to the following:

TransactionType <> 'NonTransaction' for the Transaction part of the graph

TransactionType <> 'Transaction' for the NonTransaction part of the graph

Thanks again

JP