I've built a Visualization as Data Table as Summary report in which I have multiple columns. When I click on any cell, it has to open the respective drilldown data where in which Column1 and Column2 have to be passed(to filter the respective data).
When I googled it, some body suggested that can't be done using URL parameter(only 1 value passing is possible with URL parameter) and need to use Scripted fields for this requirement.
But I'm unable to do it so. Could you please help me in this regard, please let me know if you need any further clarification. Any help will be highly appreciated. Thanks in advance.
But I need to pass 2 columns value from the Data table in my requirement.
I've checked the one of the discussion topic on the similar requirement but unable to configure in my case.
I'm unable to know exactly how to use scripted fields to pass the data table values.
Is it possible to pass 2 column values from Data Table upon clicking URL and filter data based on them in anyway(at least with scripted fields)?
Could you please help me on this as quickly as possible.
@venkata.kodapaka I think the idea would be that you use scripted fields to concatenate the 2 values together into a new field. Then you can filter on the new field by passing in 1 value with the 2 values concatenated together. It is admittedly a hacky solution at best.