5 Replies Latest reply on Jan 26, 2019 9:58 AM by Rob Guthrie

    How do I not have aggregate values in my calculation, but maintain my text table?

    Rob Guthrie

      Hello,

       

      I am joining two datasources and I my ultimate goal is to get a grand total of the resources inside my dataset. Where I am having difficulty is that my joined datasets are making the numbers appear more inflated that I would like. Here is an example: Server CW123 has 6 cpus and 5 file systems, but when I am attempting to add this into a measured field, it counts the CPU's as 30 because it is adding 6 cpus per file system when I just want it to be one. Does anyone have any idea how I can solve this?

       

      Thanks,

      Rob