8 Replies Latest reply on May 16, 2018 11:42 AM by Ronald McPherson

    Date Subtraction &

    Ronald McPherson

      Hello everyone,

       

      I have a data-set with security cameras that were added at various times.  I would like to create a view that looks at what cameras are averaging the most hits on a daily average.

       

      I have a calculated field which gives me a single distinct count of the hits called [# of Hits] - this is a COUNTD(hit_id) calculation

       

      Essentially I'm trying to build a calculated field like this:

       

      ([Camera Added Date] - [Current Date, aka TODAY]) / [# of hits]

       

      I feel like this is a relatively simple calculation but I keep hitting walls with the various routes I try.  In advance, thank you for any help that you can provide!