5 Replies Latest reply on Sep 21, 2016 7:18 AM by anoop.mohandas.0

    How to include Week # in LOD calculated field?

    Denitsa Kosharova

      Hi I am playing around with level of detail calculations, and so far they are great but today I am having issues with using dates in LOD.

       

      In the view I can use date expressed as week number (of the year) and I am aggregating a measurement based on week#. When I try to use this level of aggregation in calculated field, however, I cannot get the date aggregated to week number -  I can figure out days, months and years but can't seem to find the week level... any ideas how I can use the week number in LOD without actually having it the view?