Hi Team, We would like to create a report which is similar to the below structure. This will require custom aggregation from same data source and fields as shown below. Is this feasible with the current features? We would want to keep it dynamic in terms of our customer cohort selection and we can put a parameter selector for it so that it can toggle selection and change our metric results accordingly.
| Column 1 | Column 2 | Column 3 | Column 4 |
|---|---|---|---|
| Metric Name | Jan 2023 | Feb 2023 | YTD (Aggregation) |
| Customers - | 1 | 2 | 3 (Sum) |
| Revenue - | $500 | $600 | $1100 (Sum) |
| % of Total Customers Revenue | 1% | 1.2% | 1.1% (% of Sum) |
| Opportunities - | 2 | 3 | 5 (Sum) |
| % of Total Customer Opportunites | 0.2% | 0.3% | 0.2% (% of Sum) |
| Engagement - | 2 | 1 | 1 (Most Latest Value) |
| % of Total Customer Engagement | 2% | 1% | 1% (Most Latest Value) |