Forum Discussion

jfarmer's avatar
jfarmer
Cloud Apps
10-18-2022
Solved

Change Axis labels on Line Chart

I have a couple dashboards with month numbers instead of month names as the x-axis labels, and I modify the numbers to month names with the following script. It works when I am editing the widget, bu...
dashboards & reporting
  • Harry's avatar
    Harry
    10-18-2022

    Hello jfarmer ,

    I think this is because the script you added in 'domready' event. Hope below script works here.

     

    newItemMapping = { '1':'Jan',
				  '2':'Feb',
				  '3':'Mar',
				  '4':'Apr',
				  '5':'May'
				}

widget.on("queryend", function(se, ev){
	
	var panelName = 'Day Number' //Items in this panel will be replaced with new items
	
	panelIndex = ev.rawResult.headers.indexOf(panelName)
	$.each(ev.rawResult.values, function(index, value){

		
		if(newItemMapping[value[panelIndex].text] != undefined)
		{
			value[panelIndex].data = newItemMapping[value[panelIndex].data]
			value[panelIndex].text = newItemMapping[value[panelIndex].text]
		}
	})	
})

    Always here to help,
    Harry from QBeeQ
    [email protected]
    www.qbeeq.pl

Harry's avatar
Harry
Cloud Apps
10-18-2022

Hello jfarmer ,

I think this is because the script you added in 'domready' event. Hope below script works here.

 

newItemMapping = { '1':'Jan',
				  '2':'Feb',
				  '3':'Mar',
				  '4':'Apr',
				  '5':'May'
				}

widget.on("queryend", function(se, ev){
	
	var panelName = 'Day Number' //Items in this panel will be replaced with new items
	
	panelIndex = ev.rawResult.headers.indexOf(panelName)
	$.each(ev.rawResult.values, function(index, value){

		
		if(newItemMapping[value[panelIndex].text] != undefined)
		{
			value[panelIndex].data = newItemMapping[value[panelIndex].data]
			value[panelIndex].text = newItemMapping[value[panelIndex].text]
		}
	})	
})

Always here to help,
Harry from QBeeQ
[email protected]
www.qbeeq.pl

  • jfarmer's avatar
    jfarmer
    Cloud Apps
    10-18-2022

    Easy fix! Thanks a ton, this worked like a charm. 

    • Harry's avatar
      Harry
      Cloud Apps
      10-19-2022

      Very happy to know that the issue has been resolved.

      I noticed that you have a long script for widget tabber. QbeeQ created an advanced Widget Tabber with which you can create tabs without adding any script to widget.

      Please let me know if you have any questions

      Always here to help,
      Harry from QBeeQ
      [email protected]
      www.qbeeq.pl