report out of metrics

[shid077]

How to make report out of metrics for 3 months for a particular location on alm_asset table.

[Dr Atul G- LNG]

Hi @shid077 

If you need any field from alm_asset table, in that case first create a DB view with metric and asset table. and then you cna use that DVB view in reporting ( table). In report you need to use the created / updated( as per need) 3 month ago. You will get the report. 

https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/reporting/task/create-report-wit...

[Mark Manders]

Just like with PA: any data will only get stored after you create the metric/indicator. You won't be able to report on historical data until you are storing it. If you already have the metric (which I don't think you do, looking at your other questions), you can use Atul's solution. Otherwise: create the metric and start reporting on it as of now. 

As said in answers to other questions: you can't report on data you don't have.