I would like to start individually a function in r out of tableau. I need a user interface where the user insert: myFund, myBM, start_date, end_date, Grouping. The output should be shown in tableau.
function(myFund = 'fund',
myBM = 'benchmark',
start_date = '2013-03-29',
end_date = '2018-03-30',
Grouping = 'gics')
My aim is to calculate individual performance attributions in r and show them via tableau. May you habe other ideas.....
I am not aware of R language nor R coding.
ok, thanks. Back to my question about the filtering. I want to have the filters in the Dasshboard...
Please check my earlier reply,it has a link related to filters.
Different kinds of filters can be created in tableau.it is possible.
You can add filters to the dashboard and show them at the top above the headers like you can view in excel.
Build your sheet and show all the filters you want to view on the dashboard.
When you start building your dashboard, before you drop your worksheet, select floating instead of tiled on the left layout side bar.
When you drop your sheet on the dashboard. all your quick filters will also be visible on the dashboard.
Since you have chosen floating option, the filters are not shown to the right of the sheet by default you can arrange them at the top properly.
Workbook Attached - Please check Multiple Filters sheet and the dashboard
stdsol.twbx 1.3 MB
It is not that easy as you see in the picture above there is a slider for the horizontal so my arrangement of the filter would be useless at the moment when I use my slider...
You can arrange in 2-3 rows or use one filter to select the measure you are filtering on and another to filter the actual value.
You can then build in calculated field to apply the selected value from the slider to filter the measure selected.
Group the measures to have similar or dependent measures together etc.
It is better to have as few filters as possible. You can try to identify what filters will be most useful and only have them on the dashboard .
Maybe build in ranges and have drop down filters instead of the sliders.
Depends on your data really.
1 of 1 people found this helpful
Better and simple way is to take Tiled dashboard.(It may helps you to fix and movable as per your slider)
Step1: Take one vertical and one horizontal container
step2: Drag your detail report to vertical container(Bottom one)
Step3: Drag your each filter to Horizontal container(Top one) and align width of each filter as per your bottom report
* More quick filters can degrade your workbook performance
* Better to give drop-downs for higher granularity fields and cascading filters(ignore this point if it wnt match in your case)