Boolean Datatype

Hi Rahul09 ,

Assuming this one column is populated by a few text options (words) , is it possible to apply a JS script that detects those words and replaces them with True\False by any logic you apply.

With that in mind, it's a pretty easy and straightforward use case.

What if you want to replace words with numerical boolean (1\0) and perform a calculation upon it? 
What if you don't know which text will appear in this column and you want to apply complex logic for the boolean replace?

For these exact use cases, I would recommend looking at Sisense API documentation on pivot tables:
https://sisense.dev/reference/js/widget/pivot2.html
You can write a script using pivot APIs to apply complex logic.

Another option is to use Paldi Solutions Expandable Pivot - which exposes a customization API in the plugin and helps you to manipulate pretty much everything within your pivot table.
Let's take the image below as an example:

In this pivot, I have decided to add numbers, arrows, and brackets based on a logic that was easily customized with our customization API.

If this is something that interests you drop me a message or contact me via email and I would be happy to show you this capability and provide a free trial.