Performance analytics report to compare the current month data

[Zorawar Singh 1]

We are trying to build a timeseries report for a current month yearly comparison of assets using performance analytics but cant find a way to do so. 

For example if the current Month is August then we want to compare asset data for August2023 vs August2022 vs August2021 . If the current month changes to Sept then it would be a comparison of Sept2023 vs Sept2022 vs Sept2021.

We will have to collect the data monthly because we need the data present for all months from previous few years but not sure how to restrict the comparison just to the current month in the Widget.

[AndersBGS]

Hi @Zorawar Singh 1 ,

What is it that you would like to compare from assets? The amount or? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Zorawar Singh 1]

Hi Ander,

We need to compare the total cost of Assets.

Thanks & Regards,

Zorawar Singh

Thanks & Regards,

Zorawar Singh

[AndersBGS]

Hi @Zorawar Singh 1 ,

Ok, and the cost for a single asset - which table and field have you that listed in? 

Furthermore, I guess that you would also filter on the asset state? correct? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Zorawar Singh 1]

Hi Anders, 

We want the sum of cost for all the assets  where state is not retired from the alm_hardware table for model category computer. We are using a custom field similar to cost field on this table to build this report .

We built the report for the total cost monthly using PA but not sure how to pick specific months from each year to show on the report as per the requirement. Appreciate you help

Kind regards,

Zorawar