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.
Can anyone have idea how can I archive this chart?