Calculated Fields

  1. What is the use of Calculated Fields?

Hi @nivethitha.ponnambal

There are three types of fields available to create the calculated fields. (i.e) Date, Dimensions, and Metrics

Screenshot from 2023-03-17 17-23-24

For eg:

We have a column called Refund Amount and Return Amount in one report. Using these calculated fields we can create calculated filters based on the condition. Once validation is a success we can save that and publish them.

Then we can find this calculated dimension in the filter section in the report and add them.

Screenshot from 2023-03-17 17-48-44

Screenshot from 2023-03-17 17-48-50

After adding we can start applying that condition Either ā€œYā€ (or) ā€œNā€ and it will give us the result based on the filter value.

Similarly, we can try the other two types as well.

Thank you.