Latest Date

Answered

Comments

8 comments

  • Avatar
    Sam Ovenshine

     Hi Mike,

    {
    "top": 1,
    "by": {
    "table": "TableName",
    "column": "FieldName",
    "dim": "[TableName.FieldName (Calendar)]",
    "datatype": "datetime",
    "merged": true,
    "level": "days",
    "agg": "max"
    }
    }

    Can you try something this on one of your datetime fields? Replace the table and field names with yours.

    2
    Comment actions Permalink
  • Avatar
    Jeremy Naiden

    Hi Sam,

    I'm looking for something like this but that pulls the latest date by row.  For example, my particular use case would be the dates a product was first listed.  This is tricky because there are many stores that each product is sold at, and I'd want to pull the most recent date across all of the stores for each product.  Thoughts?

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    Is there a way to change the default text that is displayed? We would like to display something informational, like "Last Benchmark Available".

    1
    Comment actions Permalink
  • Avatar
    Marcin Saktura

    Hi, 

     

    Wonder if there is a way to filter latest date from coluomn USE DATE for each client. 

    For example:

    I want to see only latest use date for each client:

    For AA should show only 03/02/2019 but need to keep use date for BB and AAAA. 

     

    I would be thankful for any help. 

     

    Best regards

    Marcin 

    0
    Comment actions Permalink
  • Avatar
    Anjali Yadav (Edited )

    Hi Marcin

    This was our work around for a similar request - 

    Convert Date values as Int and store them in a new INT type column in your sql table. Refresh connection , rebuild your elasticube and then on the dashboard use theis newly added INT type column with MAX function applied, that will show the max/latest date.  

    In the Edit Script of the widget add a code to insert '/' in the int values to show them as dates.

    An

    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi Jeremy,

    I just published an article for Latest Date Dashboard Filter that covers this exact filter type.

    Hope you will find it useful.

    Regards,
    Inbal


    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Hi Inbal,

     

    Your article seems to be really interesting, unfortunately, the link seems to be broken and your profile page in the support platform does not include this article. Can you republish it ?

    Best, David.

    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi David,

    Thank you for your feedback. Please try this link instead.

    Regards,
    Inbal

    0
    Comment actions Permalink

Please sign in to leave a comment.