Hourly Evolution - Chart with last 24 values

[#1]

I'm looking for a chart with the last 24 values according to an hourly evolution, in a real time database.

How can I do this?

Thanks!

[Clever_Anjos]

First of all you need to extract your data from  your database

• Configure an ODBC entry to the database OR
• Configure an OLEDB connection to your datase
• Write an SQL query that brings the data you need
• Create you graph

[jyothish8807]

Hi Marcelo,

You can use dimension limit (Largest 24 values) or rank function in you chart to limit the latest 24 values.

may be u can use reloadtime() as a dimension to limit it or if you have a filed which changes on each load.

Regards

KC

[vishsaggi]

Hello Marcelo,

Once you get the data as suggested by Clever Anjos...

Use the straight table and Add dimensions(Hourly Evolution) and expressions as per the requirement.

Then in the Dimension Limits Tab in straight table Restrict the values to Largest 24.

Snapshot attached.

Try and let us know if that works.

If you have any sample data file we can work on, that would be easy.

Thanks,

V.