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.
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?