I want to display KPIs of the current user

[KilifiWebGuru]

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?

[artur]

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

[KilifiWebGuru]

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.

[artur]

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

[KilifiWebGuru]

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

[artur]

@KilifiWebGuru something like this

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