Re: [I] Choose dimension to split with at the dashboard level [superset]

["mvsenin (via GitHub)" <gi...@apache.org>]

mvsenin commented on issue #3962:
URL: https://github.com/apache/superset/issues/3962#issuecomment-2463966031

   Hello everyone,
   
   I'm not sure it helps, but we actively use URL params for data filtering. Firstly, it's necessary to design your data model since this approach applies using Jinja's {{url_param()}} in dataset SQL queries. So, each or almost each chart of you dashboard(s) should be using a dataset with corresponding conditions in the WHERE clause, e.g.
   
   WHERE YourDimension = '{{url_param('DimensionName')}}'
   
   Finally, your dashboard(s) can be invoked with the param in its URL, say:
   
   htttps://TheServer/DashboardSlug/?DimensionName=DimensionValue
   
   So, the condition below will be translated to the something like that:
   
   WHERE YourDimension = 'DimensionValue'.
   
   Please read Jinja docs, maybe that can help.
   
   Wish you luck.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org