I want to display KPIs of the current user

Hello fam. How can I display KPIs of the current logged in user in the summary card block? How can I design the database for this operation?

@KilifiWebGuru you could use conditional filters to filter by current user

Here is a screenshot of my data source. As you can see, I have just a summed up data, not based on any particular user.
Screenshot from 2023-05-21 12-46-54

If you need per user filter then I guess you need per user sums and user email in the table above

I still haven’t figured out how to do that. Would you please help me figure out how to design/ structure my DB.

@KilifiWebGuru something like this

Email | KPI | Value 
artur@gmail.com | Target | 100
james@gmail.com | Target | 200

How do you do when you have multiple metrics and want to show only logged users?