1 Reply Latest reply on Oct 3, 2012 11:53 AM by Mark Holtz

    How to calculate occurances per day?

    Joshua Dobson

      I am trying to create a distribution chart to show daily average production statistics per user.  How do I create a measure for the COUNTD of products per day?  

        • 1. Re: How to calculate occurances per day?
          Mark Holtz

          Hi Joshua,

          Without seeing your data, I am guessing at what it looks like.

          Could you post your workbook as a packaged workbook?

           

          It sounds like you already have most of the pieces you need...

          You can create a calculated field as COUNTD([ProductType?])

          Then you just need to place it in a table along with the DATE you are interested in grouping by...