2 Replies Latest reply on Nov 9, 2018 12:53 PM by Chase Patterson

    Reference results of a calculated field

    Chase Patterson

      I have information that i have utilized date scaffolding, and within the full data it has the results that i need, but when i attempt to reference this along with the date scaffolding it shows me every instance.

       

      e.g. i have calculated how many animals i have everyday of the year, then i want to know what was their status as of the date referenced (f1). When i attempted to add status it shows me multiple entries per animal because of changes to their profile. Although if i look into the full data of the aggregated animals it shows me the status as of the date (f1) referenced.

       

      I hope this makes some sense, i have attached a packaged workbook as well.

       

      Thanks!~