5 Replies Latest reply on May 11, 2017 6:23 AM by Zhouyi Zhang

    Filtering duplicated data sources separately

    Nathan Brown

      Hi everyone,

      I have searched through and can't find anything that has fully helped me with my problem.

       

      I want to create a utilisation percentage for some assets based on the amount of time they are used (Travel time/asset count in the workbook).  I can do this for the entire data set with no problem as it picks up all of the assets to calculate the total time.  The issue comes when i filter the data based on my parameters to a shorter time frame.  the asset count reduces to count only what has been active over that time frame.  If I take away the linking field then it doesn't show the data by day, which is required.

       

      I have attached an extract of the data for a month, not sure if i'm on the right path or have to go about it another way.

       

      Thanks,

      Nathan.