3 Replies Latest reply: May 29, 2012 5:41 AM by Jean-Paul Camelbeek RSS

    Set Analysis

      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