{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/418915d985834334bb214a6a0bfcb4d6\" frameborder=\"0\" width=\"1636\" height=\"1227\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1227,"width":1636,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1227,"thumbnail_width":1636,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/418915d985834334bb214a6a0bfcb4d6-f972944906110680.gif","duration":199.5496,"title":"Optimizing Contextual Filters for Database Views 🔍","description":"In this video, I discuss my current work within the Options Database and how it connects to the Consolidation and Facts databases. I'm trying to group options by their associated consolidations, but I'm encountering an issue where unrelated consolidations are appearing in my results. What I really need is a contextual filter that allows me to see only the consolidations linked to the current option I'm viewing. If I can implement this filter, it would significantly enhance the relevance of the data I'm working with. I'm looking for insights or suggestions on how to achieve this contextual filtering across the databases."}