cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Trouble binding sql query data to chart

RandyGui
4-Participant

Trouble binding sql query data to chart

Hi,

I am new to TWX and I am trying to create a simple mashup one time series chart.

At "View mashup", I am getting a blank chart, but "Debug Info" shows that I  have several rows returned.

What am I doing wrong?

 

Thanks in advance.

Randy

 

Debug info.JPGChart.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyGui
4-Participant
(To:supandey)

Hi Supandey

 

It seems that I made a mistake with data column name and it's alias name.

chart's working fine now.

 

Thanks again for your help.

 

Randy

 

View solution in original post

4 REPLIES 4
supandey
19-Tanzanite
(To:RandyGui)

Hi @RandyGui may be this is an issue with the DataShape which is being used in the service's output. While it is correct that your service is working fine by returning x number of rows, however what should be checked here is that what DataShape is assigned to the output and what has been selected for the X & Y axis properties for the Time Series chart. See Time Series Chart Widget property details here

supandey
19-Tanzanite
(To:supandey)

Quick mention: The link shared in my reply also contain link to the video tutorial on how to configure the chart
RandyGui
4-Participant
(To:supandey)

Hi Supandey

 

It seems that I made a mistake with data column name and it's alias name.

chart's working fine now.

 

Thanks again for your help.

 

Randy

 

RandyGui
4-Participant
(To:supandey)

Hi supandey,

 

I'm at work atm and blocked from Youtube. I'll take a look at the vid after work.

 

Infotable is assigned as output BaseType.

The datashape assigned to output has 2 fields with datetime and integer as BaseType.

 

Here are the property settings.

Properties.JPG

 

Regards,

Randy

 

Top Tags