Jump to content
  • 0

Filter by Most recent (latest) date


mferguson
 Share

Question

I am creating a tabular summary report. The data source has list of dates with some other data fields and a corresponding ID number. I would like the report to just display one record for each ID number - the one with the most recent date - but the method to do this escapes me.

There are a lot of different ways to filter data (i.e. http://howto.caspio.com/datapages/creat ... types.html) but a 'maximum' or 'latest' criteria does not appear to be in there in terms of filtering either in reports or views.

I thought of using a maximum aggregation within the data display, but all that does is gives me the latest date and does not pull the other fields for that specific record.

Anyone else ever tried to do this or have any thoughts on an approach?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Hello mferguson,

Let me see if I get your question correctly say you have a report like this which is grouped by IDs:

ID Date

55 12/12/2010

10/12/2010

08/12/2010

56 08/12/2011

07/12/2011

06/12/2011

and now you wish to see this report like below:

ID Date

55 12/12/2010

56 08/12/2011

Well, if that's the case then it can not be done in one DataPage. You need to create 2 DataPages.

On the first one you can display IDs and make them linkable, then when user click the link, it passes the ID as a parameter to the 2nd DataPage which is sorted the way described in the previous post by Aariel.

Please let me know if that's the scenario you were looking for. :mrgreen:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...