How to use two tables in automated indicators on single report

[Sai Rakesh2]

How to use two different  tables in automated indicators and the data should be visible on '%' format on monthly basis. Can anyone help me on this..Thanks in Advance..

[AndersBGS]

Hi @Sai Rakesh2 ,

For me to help you best possible, you need to provide some additional information. How are the two tables related to each other? Should the outcome be one percentage or two different percentages? Please provide as much information as possible, as it will make the feedback much more clear.

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

best regards

Anders

[Sai Rakesh2]

hi @AndersBGS 

1. Customized table on case

2. change table

We have Change(number) field on customized table

Outcome should come on one percentage only and also I should apply on Breakdowns on both the tables.

[AndersBGS]

Hi @Sai Rakesh2 ,

If I understand you correctly, you have a customized table which is an extension of the sn_customerservice_case table - correct? 

The change number on the custom table, is that a reference field?

What should the percentage show?

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

best regards

Anders

[Sai Rakesh2]

hi @AndersBGS 

1. Yes, extension from case table

2. Yes, it's reference field

3. change field is not  empty on case table records / Total number of change on change table