Skip to main content
16-Pearl
Dec 31, 2024 9:36 AM UTC
Solved

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

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

16-Pearl
Jan 9, 2025 9:26 AM UTC

Hi @wcui

 

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

 

Thanks You.

 

Regards,

Aditya Gupta 

3 replies

16-Pearl
Jan 6, 2025 4:09 AM UTC

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 

Translate
16-Pearl
Jan 9, 2025 8:43 AM UTC

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

Translate
Aditya170216-PearlAuthorAnswer
16-Pearl
Jan 9, 2025 9:26 AM UTC

Hi @wcui

 

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

 

Thanks You.

 

Regards,

Aditya Gupta 

Translate