How-Tos & FAQs

How To Concate Three Strings In Elasticube

Question: I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on.Solutio...

Editing An Existing SQL Custom Import Query

Question: I want to edit existing Custom Import Query, how can I do so? Solution: From the context menu open on the table with custom import query Change connection settings for table: From there you will be able to see your custom import query...

Accumulation Build For Millisec (Ms) By Using Unix Timestamp Transformation

Question:This post we will talk about accumulation via millisec by using a unix timestamp transformationIn this use case, We will be working with a CData Elasticsearch ODBC driver and client need a way to accumulate data base off milliseconds.Naively...

Using SQL Coalesce To Handle Null Values

Question:SQL NULL is not technically a value, but rather a state. Fields are not equal or not equal to null, they are or are not null. As such, null fields can get a little tricky when attempting different kinds of transformations.For example, mathe...

Removing Leading Zeros

Question: What is the best way to remove leading zeros? I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213. Solution: If all of your data with leading zeros will always be some sort of numerical string (ie ...

Split A Delimited Field Into Rows

Question: A data source in your ElastiCube contains a field with multiple values in it delimited by a particular character (i.e - comma, semicolon, space, etc.). You need to parse that field and create a table with a record for every value in the del...

Sisense Community

How to check specific pods CPU/memory consumption in Grafana

Knowledge Base Articles