How to filter results to show only the last 30 days?

Comments

5 comments

  • Frances Angulo

    ah! Partitioning RESULTS is not the same as partitioning the source data. Go back to your source artifact, click the gear (to configure) and look near the bottom of the schema definition screen for "Use Time Based Partitions". Check this out: https://documentation.datameer.com/documentation/current/Partitioning+Data+in+Datameer#PartitioningDatainDatameer-importJobsPartitioningDataDuringImport/FileUploadsandDataLinks

    1
    Comment actions Permalink
  • Frances Angulo

    The filter looked solid, especially if your results appeared correct- and yes- the date partitioning on the sources happens at the connection point, so your admin would likely need to help here :)

    1
    Comment actions Permalink
  • Frances Angulo

    Hi there!

    There are many advanced filters you can use to do this- but have you considered partitioning the data at ingest so that you can filter results based on those partitions? You can create filter sheets with different time frames and use those as sources for other workbooks.

    0
    Comment actions Permalink
  • MorganM

    I think I got this to work... #end_time >= NOW()-30d

    I'm not sure how I'm failing at partitioning data but I can't seem to get it to work. I save my workbook, I configure partitioning under "Save Results and Time Based Partitioning", run the workbook, then go back in and the "Partition Filter" button is grayed out.

    0
    Comment actions Permalink
  • MorganM

    by 'source artifact' you are referring to my datasource.dst connection where I pulled data into my workbook originally right?

    That being the case I do not have permissions to edit that. I can get with my Datameer admin to do this but I can't do it right this second =(

    What do you think about my advanced filter though? I did a quick validation on a new sheet to GroupBy end_time and only 30 entries came back... the previous 30 days.

    0
    Comment actions Permalink

Please sign in to leave a comment.