cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

This post we will talk about accumulation via millisec by using a unix timestamp transformation

In this use case, We will be working with a CData Elasticsearch ODBC driver and the client needs a way to accumulate a database of milliseconds.

Naively, we are unable to accumulate down to the millisec but with this work-around, we are able to do so.

Answer

This will be done upon data pull in from your data source where we will edit the query and transform it into a unix timestamp

 

Please keep in mind this is using a function from your native data source. 

 

In this case, we are using ODBC CData and they support the function we needed for this transformation

By using the following function, we are able to bring in data and transform into unixts

Use this SQL code:

SELECT datediff('millisecond' ,DATEFROMPARTS(1970, 1,1),datetime) 

FROM demosisense.testDate

After this has been completed, you can now go ahead and set the accumulation base off the new field we created. Following the regular Sisense function, we can then hide this field while doing an accumulative build on this.

And this will accumulate down to the millisec!



Version history
Last update:
‎10-16-2021 06:36 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy