I want following 2 fields of my custom object to be present on the report chart.
- Tier (Bronze/Silver/Gold/Platinum)
- Tier Date (Indicates the date when the customer is upgraded or downgraded to particular tier).
So, my goal is to prepare a chart that shows when the Custom Tier upgraded/downgraded over the time. For that, Tier Date should be on X axis and Tier should be on Y axis. But I'm not allowed to use both fields without using aggregated functions like sum, count, avg etc. in salesforce report builder.
Here I'm attaching screenshot of expected output.
Can anyone have idea how can I archive this chart?