How to calculate a combined metric from two database views.

[Gourav2000]

So I have two database views where I need to calculate the average CSAT scores from two separate views. Each view contains a CSAT column and my goal is to calculate the average CSAT scores from each view and then determine the overall average of these two averages. This average score needs to be shown in a gauge component.

Any advice, insights or examples will be greatly appreciated.

[Danish Bhairag2]

Hi @Gourav2000 ,

You can try Performance analytics for this where u can use multiple mathematical formulas in order to get the output.

Example on how to create a report using PA

https://www.youtube.com/watch?v=u1k0kplZlZY

Thanks,

Danish