Forum Discussion

BeckyCrittenden's avatar
BeckyCrittenden
Cloud Apps
12-07-2023

Text Aggregate functions

Does Sisense have text aggregate functions available to use for comparing text values? Some data fields require use of an aggregate function, but unable to identify a specific function to use in aggregating text values. 

Is there a function to allow for this? Thank you!

2 Replies

Replies have been turned off for this discussion
  • AssafHanina's avatar
    AssafHanina
    Sisense Employee

    Hey BeckyCrittenden , 

    Sisense provides the ability to utilize Count and Count Unique functions with text fields at the dashboard level. Elasticube offers various string and text functions for data model transformation and subsequent use in the dashboard. You can refer to the official documentation for more details.

    Moreover, Sisense allows for the utilization of Custom Code and Custom Code Transformation, 
    to leverage the power of Python using Jupiter notebooks

    Best Regards,

    Assaf
     

     

  • Hello there,

    Before importing the dump file into AWS to connect your instance By SSH, you can upload the dump file via SCP or SFTP, then access your database system, and you will create a new database.

    Best Regards,