This definitely works, however I was trying to push all my KPIs to the semantic layer as this is a best practice recommendation. And on top of that once I manage to calculate total_credit_limit I have several more metrics such as utilization ratio, w...
Hello @SteveOstrowski Having a table cards_daily_snapshot with columns time_key, month_id, account_id, card_id, credit_limit, account_status. Need to create a metric for total credit limit, by getting the max value of it per account_id and snapshot d...
