AnsweredAssumed Answered

Dashboard - Line Chart - SQL Data source

Question asked by DanielMarques81982792 on Dec 9, 2015
Latest reply on Sep 22, 2017 by Marco_Ippati

Hi

 

I want to create a line chart using a SQL data source

 

But when I associate the SQL data source online chart, you create a period starting in 1970

 

could help me understand my mistakes?

I do not understand the operation of the chat using SQL data source

You need to read a value or a period?

 

Query:

selectsamplevalue, sampletime
  fromRN_QOS_DATA_1247
whereDATEPART(dw, sampletime) = 2

   and  table_id = 1080544

 

Error print:

 

chart error.JPG

Outcomes