3 Replies Latest reply on Jul 4, 2018 6:05 PM by Ph C

    Split field into column to apply pie chart

    Ph C

      Hi,

       

      I have a table like following:

      BookIDLocationFacility
      1Kwun Tong1
      2Kwun Tong123
      3Kwun Tong13
      4Kowloon Tong2
      5Kwun Tong
      6Kowloon Bay2
      ......

       

       

      And the facility is read as following:

      1: Tea

      2: Screen

      3: Mic stand

      ...

       

      Is there any method to split the facility value and show the pie chart which represent the % of facility usage for each location.