https stackoverflow com questions 64076579 filter-data-with-parameter-tableau

0 votes

I'm attempting to use tableau to filter data using a parameter based on user id. User id, content team, and seconds are the three columns. The following are some examples of sample data:

 user_id | content_team | seconds
    1    |     AR       |  2000
    2    |     VR       |  1000
    1    |     AR       |  3000
    2    |     VR       |  4000
    3    |     HOLO     |  5000

I currently have the content team's sum(seconds) for all users combined.

How can I make a parameter that accepts a user id and displays the sum(seconds) of the content team for that user alone? Thanks a lot

Mar 24 in Tableau by Neha
• 8,560 points
34 views

1 answer to this question.

0 votes
The most typical scenario for utilising parameters in filters is when you have many data sources that are not connected but have a common field. When there is only one data source, parameters are of limited use since basic filters function better.

When you need common filters across numerous sources, but can't combine them into a single source because you don't want to lose part of the functionality in each sheet, parameters come in handy.

If you have many data sources with varying degrees of detail but all of them have the same filterable field, such as user id, you may define a parameter based on that field (and recent versions of Tableau can automatically update the content of the parameter on loading the workbook). To filter across the sources, add a parameter called user id parameter that is updated when the workbook is opened, and then filter each individual page using a calculation like [user id]=user id parameter, where the user id comes from the applicable data source in each case. When the parameter is modified, each distinct data source will be filtered to reveal just the data associated with that user id, even if the data sources are otherwise unrelated.

This capability greatly simplifies the process of developing "universal" filters that operate across many data sources in a worksheet (now that parameters may change on load).

If you just have one data source, the strategy still works, but it's no better than simply filtering on the appropriate field (and don't forget, you can apply a filter to all sheets or a range of sheets).
answered Apr 5 by Vaani
• 6,820 points

Related Questions In Tableau

0 votes
1 answer

Highlight data with an filter/parameter

Hi, Follow below steps: 1. When you add ...READ MORE

answered Apr 1, 2019 in Tableau by Cherukuri
• 33,010 points
158 views
+2 votes
1 answer
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 20, 2018 in Tableau by sdfg
• 5,550 points
7,315 views
+1 vote
1 answer

Tableau - Filter/Parameter For Different Date Ranges

Based on your comment and updated question, ...READ MORE

answered Jul 20, 2018 in Tableau by sdfg
• 5,550 points
486 views
0 votes
1 answer

Tableau Public Background Images Not Working

The functionality you're talking about (Map -> ...READ MORE

answered Mar 3 in Tableau by Vaani
• 6,820 points
34 views
0 votes
1 answer

Tableau Public Background Images Not Working

The functionality you're talking about (Map -> ...READ MORE

answered Mar 3 in Tableau by Vaani
• 6,820 points
50 views
0 votes
1 answer

Creating a stacked waterfall chart in tableau

You can try this as a solution: 1.) ...READ MORE

answered Apr 5 in Tableau by Vaani
• 6,820 points
114 views
0 votes
0 answers

Tableau report sharing

We have a number of historical tableau ...READ MORE

Mar 22 in Tableau by Vaani
• 6,820 points
18 views
0 votes
1 answer

How do i get datetime into a tableau extract with pantab?

Panda dtypes handle dates and strings as ...READ MORE

answered Mar 14 in Tableau by Vaani
• 6,820 points
45 views
0 votes
1 answer

Tableau: How to create a filter based of 3 different columns?

The case you're using for filters is ...READ MORE

answered Mar 16 in Tableau by Vaani
• 6,820 points
331 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP