cancel
Showing results for 
Search instead for 
Did you mean: 

Adding indicator to pivot table

Pavan_Kumar17
7 - Data Storage
7 - Data Storage

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

2 REPLIES 2

Angelina
9 - Travel Pro
9 - Travel Pro

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 = "🟠";
       } 
});

Angelina_0-1671706247646.png

Hope this helps!

Always here to help,

Angelina from QBeeQ
angelina.bulgakova@qbeeq.pl
QBeeQ  - Gold Implementation and Development Partner

Helena_qbeeq
8 - Cloud Apps
8 - Cloud Apps

Hi @Pavan_Kumar17 ,

As @Angelina 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 info@qbeeq.pl or to me directly for more information 🙂

Always here to help,
Helena from QBeeQ
helena.ferreira@qbeeq.pl
QBeeQ - Gold Implementation and Development Partner