As a beginner in Tableau, I am dumbfounded that something that seems so easy is so difficult, or is it?
I've attached my workbook. My problem is I need to be able to select multiple values in a parameter because of a workbook I have connected to a SQL stored procedure. I would like the user to select multiple regions, and that fires back to the stored procedure to include only the region's selected. Since I can't select multiple values in a parameter. I need to find a work around.
I figured the easiest way to do this is create a filter, and then a calculated field that concatenates all of the selections made in the filter, and then I can add the concatenated line in a parameter that would fire back to the stored procedure (I will worry about breaking down that line in SQL so no need to do it here).
The issue I am having is the calculated field I am using below becomes a table calculation and an aggregate, and therefore cannot be added to a parameter.
I created this calc field named "Region"
previous_value(attr([Man Region Name]))+ if index()>1 then ", "+ attr([Man Region Name]) else "" end
and then this calc field named "Region Final" to get my final result (I couldn't do in the same calc field because Tableau doesn't allow previous_value and window_max in the same calc)
if window_max(len([Region])) = len([Region]) then [Region] else "" end
I've spent a lot of time on this, maybe this isn't even the route to go. But basically all I need is to somehow have tableau concatenate all the selections made in a filter into one line, and then tell the stored procedure what those selections are by using the parameter.
It seems silly to me if this isn't possible. There has to be a way!!!
I'm on a very tight deadline, can anyone help me???!!!!
Jonathan Drummey I've seen lots of stuff from you on the web similar to this but nothing that's worked, do you have a solution??!!!
Region.twbx 4.8 MB