Target Counter Widget to support custom SQL

[Martyn Houghton]

At the moment you have to use a 'Measure' as the source of the data for the Target Counter Widget in Advances Analytics. Though you can set the Widget to refresh as fast as every minute, the measure you have to use as the source can only be updated as frequently as each day.

It would be useful to be able to use custom SQL query with the Target Counter Widget, so allowing you to use these more in real time. The example we wanted to use was for a 'System Health' dashboard which would pick up in near real time requests which are unassigned, requests at New status and not picked up within x minutes etc.

Cheers

Martyn

[NeilWJ]

Hi Martyn,

See my other response to your other post, sorry replied to that first. If you want a more real time counter then why not use the count list widget with just 1 item defined? It will look pretty much like a target counter then (apart from the previous and diff values) and should allow you to do what you want with any custom sql.

Cheers

[Martyn Houghton]

@NeilWJ

Are you able to set a target value and for it to change colour based on a target value?

Cheers

Martyn

[NeilWJ]

Yes you can do that. Can set colour for 2 target values..so like warning and a breach

Cheers

[Martyn Houghton]

@NeilWJ

Thanks, I was not obviously paying enough attention. That should do what I want to achieve. 

Cheers

Martyn