Here an example, goal is rotate along the z axis of the character, to get the z axis we get the up vector of the character.
CharacterBP
Graph
You can use a timeline instead of function timer if you want.