Redash: Enable a drill-down path with parametrized queries

[arthurpsmith]

Now that re:dash supports queries with parameters it seems logical to allow a way to link the results of a top-level query to related parametrized queries. For example, say I have a query to fetch a list of most downloaded pages on a site, giving a table with page, total count. I might want to link each of the counts to a second parametrized query showing the counts for that particular page by day. And then the link for a particular day might go to a table listing all the detailed download events on that day for that page, or a query showing IP addresses, etc. Basically a mechanism to drill down from a top-level table or chart to more detailed queries.

I believe there's some work going on regarding formatting options for tables, so the table piece of this at least might be a related issue: add an option in formatting a particular column of a table to link that column to another query that using one or more of the fields of that row as parameters.

[arikfr]

This is a good point. Meanwhile, you can already create those links in tables, see this as an example: http://demo.redash.io/queries/520/source#table

It's crude but will work.

[arthurpsmith]

I guess that isn't a terrible workaround - thanks...

[arikfr]

Configuration for table visualization

[arikfr]

Closing in favor of #1356.

[rywager]

Need this for graphs/charts as well though.

[rywager]

Also, any clue on how to do this with Impala as a datasource?

[rywager]

Never mind: select concat('', cast(a.ip as string), '') as 'IP Link',

[dharasd03]

This is a good point. Meanwhile, you can already create those links in tables, see this as an example: http://demo.redash.io/queries/520/source#table

It's crude but will work.

Could you please tell me how to do it in MongoDB.
Thanks