-
1. Re: Running Count Of Distinct Applications Per Month
Joe OppeltFeb 14, 2018 12:43 PM (in response to Cameron Powers)
FIXED looks at all your data (whether or not you have filters on your sheet) and does what you tell it to do.
{FIXED [Standardized Name]: MIN([Captured Date])}
This will take all the rows for each [Standardized Name] and grab the min of all the [Capture Date]s, and on all rows for a given[Standardizwed name] the value in the calc will be that same min value.
The best way to understand how something works is to create a test sheet and display the value. So create that calc. Put [Standardized Name] on ROWS. Put [Capture Date] next on ROWS. Put the new calc next on ROWS. For each [Standardized Name] you will see a separate row doe each [Capture Date], and following each [Capture Date] you will see the earliest date of all the capture date on each row.
And a FIXED LOD can be a dimension.
Now you can do some other calc that will act only if the [Caprture Date] is equal to the Earliest Capture Date:
COUNTD( IF [Capture Date] = [Earliest Capture Date] then [Standardized Name] END )
(Yes, you can do IF logic inside a function!)
Now you will count things only if the row is the earliest.