Skip to main content
16-Pearl
December 31, 2024
Solved

How to give Year/Quarter/Month/Day as XAxisField to bar chart

  • December 31, 2024
  • 2 replies
  • 842 views

Hi Everyone,

 

Can anyone help me in how to give Year/Quarter/Month/Day as XAxisField to bar chart in ThingWorx.

 

Thanks in advance.

 

Regards,

Aditya Gupta

Best answer by Aditya1702

Hi @wcui

 

We had raised a case too so the solution suggested was to modify the query.

 

Thanks You.

 

Regards,

Aditya Gupta 

2 replies

16-Pearl
January 6, 2025

Hi @Aditya1702 

Not very clear about your use-case so more details will be helpful. 

Do you want to display Datetime as category on XAis? if yes, please set the Datetime column as String type, set the bar chart widget "ChartType" property as "Column Chart".

 

You can refer to ThingWorx Help for more details.

https://support.ptc.com/help/thingworx/platform/r9.7/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/BarChartWidgetThemable.html 

16-Pearl
January 9, 2025

Hi @Aditya1702 ,


I wanted to follow up with you on this post to see if your question has been answered.
If so, please mark the appropriate reply as the Accepted Solution for the benefit of other members who may have the same question.
Of course, if you have more to share on your issue, please let the Community know so that we can continue to support.


Thanks,
Wcui

Aditya170216-PearlAuthorAnswer
16-Pearl
January 9, 2025

Hi @wcui

 

We had raised a case too so the solution suggested was to modify the query.

 

Thanks You.

 

Regards,

Aditya Gupta