Want to display only the latest engine reading hours and date of RP in a C4C report

[former_member551222]

We have a requirement in the report “Equipment, engine hours, registered product and contract” that we have fields “Serial ID, Measurement Reading Measured On, Measurement Reading Measured Value, Sort field “in the view “Equipment View”.

If we open the report we can see all the measurement readings measured on and measurement reading measured values for a single serial id screenshot-1.jpg

but we wanted to see only the last measurement readings and last measurement value of the serial ID screenshot-2.jpg and wanted to hide all the remaining measurement values.

Please let us know how can we achieve this.

Thanks in advance.

[former_member497128]

Dear navaneeth.dundhigalla,

We could not find any attached screenshots, however it seems that you want to hide fields (display attributes only without displaying characteristic) and if this is the case then after running the report, go to views tab, click on "Add FIelds" and search for that specific field which you do not want to hide (it could be available in others section) and add that field to report.

For example:

We have a field "Address" within field "Account",If you add Address in report view, you have to view Account as well.

As solution, you can search for Address and then add that field. If you add this field (could be from other section) then in report field will appear like "Address (Account)" and this way you can hide Account and display Address only.

Please check further and if we have missed anything then help us with more details/screenshots.

Regards,
Saurav Kumar

[former_member551222]

Hi Saurav Kumar,

Thanks for the reply.

My requirement is not to hide the field.

Now my screenshots are visible in the blog, please go through it once so you will understand my requirement.

Once again thanks for the comment.

Best Regards,

Navaneeth Kumar.D

[former_member497128]

Dear navaneeth.dundhigalla,

We have now understood your requirement and to check further we need below details:

-> It seems that both fields are characteristics (and not key figures). If they were key figures then showing first row would have been easier but as they are characteristics so we have to try it out.May be using condition in report, we can achieve your requirement. Please confirm if these are characteristics.

-> And please let us know from which report/data source these fields are coming. If they are standard fields fetched from standard data sources, then we can try it out in our internal systems or if these fields are custom then we would request you to raise incident and send to us.

Regards,

Saurav Kumar

[former_member551222]

Hi Saurav Kumar,

Thanks for your thought.

We have tried the above said approach an but we cannot convince business to download the report and then do the filter based on the newly created Key figure value by 1.

Can we check any other approach where there is a little work to be done to extract the data.

And also we are trying to created a new key figure which gives the value of the latest engine running hours as 1 and remaining as 0 so that later on we can hide all the rows which has 0 value in the report. Can you give us any thought about this.

Thanks in advance.

Best Regards,
Navaneeth Kumar.D

[former_member497128]

Hi Navaneeth,

We already have tried using below approach
And also we are trying to created a new key figure which gives the value of the latest engine running hours as 1 and remaining as 0 so that later on we can hide all the rows which has 0 value in the report. Can you give us any thought about this.

But could not make it work. May be we will give a try again and let you know accordingly.

Regards,
Saurav Kumar

[former_member551222]

Hi saurav.kumar02,

Thanks for the reply.

Yes, the fields "Measurement Reading Measured On" and "Measurement Reading Measured Value" both are characteristics and belongs to the standard data source "Measurement Point and Measurement Document".

We just want to display only latest value of the field "Measurement Reading Measured On" and its corresponding value of the field "Measurement Reading Measured Value" as shown in the screenshot we need to hide the remaining values of both fields.

Best Regards,

Navaneeth Kumar.D

[former_member497128]

Dear navaneeth.dundhigalla,

We checked further and find our analysis as below:

-> Field "Measurement Reading Measured Value" is available as key figure so you can do some customization but other field "Measurement Reading Measured On" is a characteristic so applying any logic doesn't seem to be possible.

-> With manual effort, you can achieve your requirement by following steps:

1) Create one calculated key figure based on key figure "Measurement Reading Measured Value" with Calculate Result As "Hide" and Calculate Single Value As "Counting All Detailed Values"

2) Add above created key figure in report with desired view as shown previously by you(and apply sorting on Measurement Reading Measured On so hat max value should appear in 1st row for each serial ID) and also add result row for field "Measurement Reading Measured On"

Above 2 steps will give you data as 1 for 1st value, 2 for 2nd value,3 for 3rd value and so on per serial ID.

3) If you want to highlight data in report then create exception and highlight the newly created key figure value where value is equal to 1. This will highlight the first row for each serial ID. (but it will only highlight the selected key figure column and not all)

Otherwise, you can download the report after first 2 steps and open the report in excel. Now use feature "filter" and hide everything except value 1 for newly created key figure. This will give you the details you are looking for (along with newly created key figure which is not needed, so you can hide this one column as well at last)

There could be other way (better way) but this is what i could think as of now. If i get to know more on this, will let you know.

Regards,

Saurav Kumar