2 Replies Latest reply: Oct 16, 2012 9:54 AM by Rob Wright RSS

    Seperating out a specific field from a set of data

      Hi there, I hope someone can help...... again!

       

      I have created a chart from following data sources held in a table called "Location_split_perc" giving the values in the chart.

       

      Location Chart.png

       

      I want to create a text box object that pulls in the result from the "Location_split_perc" of only the "office"

       

      How do I seperate out the other data or only select the three items within "Office" which are Desk, Open Space and Room?

       

      Thanks

      Rob

        • Re: Seperating out a specific field from a set of data
          Johannes Sunden

          Hi Rob,

           

          You can use set analysis to only focus on one value, in this case 'Office'.

           

          For example, if you want to count the instances of FIELDNAME where Location_split_perc=Office, the expression below would work:

          =count({$<Location_split_perc={'Office'}>} FIELDNAME)

            • Re: Seperating out a specific field from a set of data

              Johannes, that worked after a bit of swapping around and getting the fieldname and Location Split in the right place.

               

              I also used Sum instead of count.

               

              I was wondering how I could show this as a percentage - at the moment I have created a variable:

               

              VarTotOfficeUtil  - which is made up of the calculation below:

               

              =sum({$<response_level2={'Office'}>}Location_split_perc)

               

              And then used that in the Text Object to get the result 0.68

               

              =Num(VarTotOfficeUtil,'#0.00')

               

              Your continued help is appreciated.

               

              Thanks

              Rob