- What is the use of Calculated Fields?
There are three types of fields available to create the calculated fields. (i.e) Date, Dimensions, and Metrics
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.
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.