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

    Split field into column to apply pie chart

    Ph C



      I have a table like following:

      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.