Querying the elasticube to get data between two datetime fields (in sql format & jaql format)

Comments

2 comments

  • Avatar
    Omer

    Hi Yaswanth,

    Thank you for your inquiry. 

    I've created a ticket for this post, so that our support team will be able to provide you with a solution that suits your case optimally.

     

    Please note, you can track the progress of your tickets by visiting the "My Activities" page under your profile.  

    Thanks,

    0
    Comment actions Permalink
  • Avatar
    Orit Meilgendler

    Hi,

    Presenting time in the dashboard can be achieved by manipulate the data in the ElastiCube, as the web application today does not support time granularity. The easiest way is to create a custom column in the ElastiCube which is a BigInt concatenation of fields.

    For example, how to convert time to integer:

    GETYEAR([A])*10000000000+GETMONTH([A])*100000000+GETDAY([A])*1000000+GETHOUR([A])*10000

    This can vary per each other  business requirement.

    Best,

    Orit

     

    1
    Comment actions Permalink

Please sign in to leave a comment.