Individual Targets on shared dashboard

Individual Targets on shared dashboard

Hi all

I'm using Analytics to create a dashboard for the sales team. We use a standard dashboard for all members so that the data presented is consistent. I want to have an "achievement vs target" graph showing  where they are against a target. 

I can use a Target component, which looks ideal, but it asks you to enter a target. Each of our team have different targets, so this won't work unless I create a different component for each person, which is a management nightmare, and I don't know how that would be shared to all the team anyway. 

Is there a way to use a custom field as the target value? I've added a custom field to the Users record for the team members where I can enter their target. Can I use that as the target value in a component? Perhaps as a replacement string?

Olly


Moderation Update:

I'm locking this post as we have a similar case being discussed in the forum linked below. Please follow This Linked Post for further updates and discussions.