Answers.Body: <p>If you're talking about showing historical values, that might be tricky, because the data isn't necessarily in the database. Or... it is, but not <em>readily</em> available to just pull up in a search. To find out for example, whether a case was open on a particular date means going through the entire history of the case to see when it was opened, closed, reopened, etc.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-10-02T12:52:07.290Z
Answers.LastActivityDate: 2024-10-03T13:02:39.423Z
Answers.LastEditDate: 2024-10-03T13:02:39.423Z
Answers.UserDisplayName: Coleman
Body: <p>I have created a searchkit that looks at the &quot;count&quot; of open cases together with relative &quot;average&quot; rating for cases.  This is grouped by &quot;case owner&quot;.  How do I add a filter to this report so that i can pick any previous date to view this data for that date? (or set up so shows 1st of the month for example?)</p>
  
Tags: <searchkit>
Title: Adding a date filter to seachkit report (not case start or end date) but todays (or another point in time date)
ThreadText: # Adding a date filter to seachkit report (not case start or end date) but todays (or another point in time date)
  
  (Asked by: username_0 on 2024-10-02)
  
  I have created a searchkit that looks at the "count" of open cases together with relative "average" rating for cases. This is grouped by "case owner". How do I add a filter to this report so that i can pick any previous date to view this data for that date? (or set up so shows 1st of the month for example?)
  
  **Tags:** searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-10-02. Score: 1
  
  If you're talking about showing historical values, that might be tricky, because the data isn't necessarily in the database. Or... it is, but not *readily* available to just pull up in a search. To find out for example, whether a case was open on a particular date means going through the entire history of the case to see when it was opened, closed, reopened, etc.
  
  
  ---
  
  