So we have a custom detail object which uses a custom stage picklist field which we use for the path. We also have a custom status picklist field with values as unclaimed, In progress and completed to indicate if its either assigned, being worked on or completed. the status value corresponds to each stage and gets reset(unclaimed ) when moved to the next stage and the stage values progresses linearly.
we now want the ability to report days spent on each of these status values for different stages.
One not so ideal solution would be creating custom field for each status value for each of the stage values which would mean if there is 7 stages, we would need 7*3 21 fields that holds the days spent value.
Is there a better solution to handle this