Showing results for 
Search instead for 
Did you mean: 

Adding indicator to pivot table

8 - Cloud Apps
8 - Cloud Apps

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 


10 - ETL
10 - ETL

Hi @Pavan_Kumar17 ,

We had something similar in this post:
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

9 - Travel Pro
9 - Travel Pro

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