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

[Aditya1702]

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

[wcui]

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 

[wcui]

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

[Aditya1702 · Accepted solution]

Hi @wcui

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

Thanks You.

Regards,

Aditya Gupta