Change count based on Filter in Tableau

0 votes

When I click filters on my tableau dashboard, is there a method to adjust the count?

This refers to the total amount spent by consumers! I have a large number of clients, and I have COUNTD formulae that function effectively and are based on certain criteria.

However, as part of the improvement, we must include the following:

As we adjust the filter based on the amount spent, the overall number of clients should adjust as well.

Say:

We have the months of January to December (as clients' names), as well as the kind of spending and overall spending.

Customer Name TYPE Total Spent January INSURANCE 1,000 February INSURANCE 100 March RENT 150 April RENT 300 May INSURANCE 450 June CAR LOAN 359 July CAR LOAN 1278 August CAR LOAN 580 September RENT 456 October INSURANCE 1,200 November INSURANCE 100 December INSURANCE 100

I have created a filter based on the range of spent ( 100 - 1500)

image

Now, If the filter is set to ALL, then the total count of customers is 12.

If I change the filter to:

  1. 100 - 500, the total count should be 8 ,

  2. 500 - 1000 is 2, and

  3. 1000 - 1500 count is 2.

image

I tried using the FIXED function and cant seem to make it work. Can someone please help me with this?

Thank you in advance.

Mar 31 in Tableau by Vaani
• 7,020 points
203 views

1 answer to this question.

0 votes

If you use a FIXED, the numbers are calculated BEFORE the filters are applied, thus the figures aren't tampered with. To fix this, go to Context and add your filters. The filter is calculated before the FIXED in Context.

Check out Tableau's sequence of operations to get a better idea of what's going on.

https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

answered Apr 7 by Neha
• 8,940 points

Related Questions In Tableau

0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,384 views
+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 ffdfd
• 5,550 points
8,248 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 15, 2018 in Tableau by AwesomeSauce
• 860 points
973 views
+1 vote
2 answers

How to join tables based on “Calculated Fields” in Tableau?

You absolutely can join to a calculated ...READ MORE

answered May 30, 2019 in Tableau by anonymous
19,653 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
118 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
116 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
116 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
161 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP