Custom chart in Web Report Designer

Hello,

Do you see any data on chart? In custom SQL/SWQL you have to use ${FromTime}/${toTime}  or ${FromTimeUTC}/${toTimeUTC} macros in where condition.

Could you please try this:

where summary month < ${toTime}

I added that bit and get the same results when i click "Preview Results".  As my screenshot shows, I get four columns (App, DB, Web and Summary Month).  Just want those values in a column/bar graph scaled to the values.  I cannot seem to figure out why this is so difficult...

Another odd bit is that this data can be displayed as a TABLE with absolutely no problems.

I am at a loss for how to translate that in a chart. 

Hello,

For chart we need minimum 2 points to show.

there is workaround add another point.

There is example for cpuload:

Datasource:

select top 1 datetime,avgload,minload,maxload from cpuload where datetime < ${totime}

union all

select top 1 dateadd(day,1,datetime),avgload, minload,maxload from cpuload where datetime < ${totime}

Chart:

Type: column

Add all three dataseries.

Sample interval: Once a day.

Could you please modify your Custom SQL datasource and try it?

This was the issue.  Once I created a duplicate row, I was able to get the chart to display.  This shows that the Web Report Designers in very powerful, but also very complex.

Thank you for the help, LadaVarga!

Hi. How do I enable SQL. Only SWQL is enabled. The SQL radio button is disabled. Please advise. Thanks

Hello,

For custom SQL you need have admin rights. Report management rights isn't enough for Custom SQL.

Thanks