Nazeer's avatar
Nazeer
Cloud Apps
04-21-2022
Status:
Delivered

Values only in M (Million) Format

Hi Team, we are trying to format my currency value only with M (Million) format. Sisense gives a full number when the value is less than 1 M. Is there any way we can bring the values to 0.01 M....
dashboards & reporting
harikm007's avatar
harikm007
Data Warehouse
04-21-2022

Nazeer ,

Please try this script : 

widget.on('processresult', function(se, ev){
	ev.result.plotOptions.series.dataLabels.formatter = function () {
		return (this.y/1000000).toFixed(2) + 'M'		
	}
})

-Hari