search

qzyu999 / finance_tracker_app

App to track personal finances
Apache License 2.0
1 stars 0 forks source link

Can't show latest dates in Looker for aggregates #1

Closed qzyu999 closed 4 days ago

qzyu999 commented 4 days ago

Currently with Looker, there are certain score cards, but they can only aggregate doing things like min, max, mean, etc. It's not currently able to get things like the latest value by date. Need to investigate how to solve this, otherwise certain important metrics just won't be calculable.

qzyu999 commented 4 days ago

Adding the Latest Portfolio Value with 0737f7b actually doesn't work, as the spark line is tracking the Portfolio Value, if we change it to it simply becomes a flat line.

qzyu999 commented 4 days ago

This seems to have been fixed by having a scorecard to show the numeric value (with Latest Portfolio Value), then creating a sparkline chart underneath which is using Portfolio Value.

qzyu999 commented 4 days ago

The previous fix only works for the front page, for other pages where there are date filters it doesn't work. We may need to investigate further how the joins work and how we can get it to do what we want.

qzyu999 commented 4 days ago

This seems to be a problem where you can't filter for the max date, relative to the current drill down. We can try to move this to Streamlit, and we can get a new POC going, will open a new issue for this. Closing this issue as of now.