Adding indicator to pivot table

[Pavan_Kumar17]

Hi Team,

Is their any option to add indicators to the Pivot tables based on the values.

For Example:
if value is zero than it will be red color tick
if value is greater than 0 & < 1k than orange color tick
if value is >1k than green tick

Thanks in Advance 
Pavan

[Angelina_QBeeQ]

Hi @Pavan_Kumar17 ,

We had something similar in this post: https://community.sisense.com/t5/build-analytics/adding-symbol-in-pivot-table/m-p/2171.
You can duplicate your measure and change it to tick in the script.
For example, I had a duplicated measure as "sign" and the following script:

const myTarget = {
 type: ['value'],
 values: [
  {
   title: 'sign' // put here desired column
  }
 ]
};

widget.transformPivot(myTarget, function(metadata, cell) {
        if (cell.value >= 10000) {
     cell.content = "🟢";
       } 
	else if (cell.value < 7000) {
     cell.content = "🔴";
       } 
	else  {
     cell.content = "🟠";
       } 
});

Hope this helps!

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ  - Gold Implementation and Development Partner

[Helena_qbeeq]

Hi @Pavan_Kumar17 ,

As @Angelina_QBeeQ mentioned, you can insert indicators in your table using script, and adapt those to your needs.

You might also be interested in hearing from our enhanced table plugin, that has that same option out of the box. Please feel free to reach out to [email protected] or to me directly for more information 🙂

Always here to help,
Helena from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner