<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Dusan Kondic on Medium]]></title>
        <description><![CDATA[Stories by Dusan Kondic on Medium]]></description>
        <link>https://medium.com/@dkondic?source=rss-13bfc78745d1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*aepw4aqHDeqqVj_cFHrj1w.jpeg</url>
            <title>Stories by Dusan Kondic on Medium</title>
            <link>https://medium.com/@dkondic?source=rss-13bfc78745d1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 11:48:56 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@dkondic/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Why Tableau ‘Context Filters’ Are Useful?]]></title>
            <link>https://medium.com/@dkondic/why-tableau-context-filters-are-useful-d54a91236bb4?source=rss-13bfc78745d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/d54a91236bb4</guid>
            <category><![CDATA[filters]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[tableau]]></category>
            <dc:creator><![CDATA[Dusan Kondic]]></dc:creator>
            <pubDate>Wed, 15 Feb 2023 08:25:34 GMT</pubDate>
            <atom:updated>2023-02-15T10:23:14.185Z</atom:updated>
            <content:encoded><![CDATA[<h4>And How Do They Differ From Standard Filters?</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8ra8d9aA_EeEyBSj" /><figcaption>Photo by <a href="https://unsplash.com/@isaacmsmith?utm_source=medium&amp;utm_medium=referral">Isaac Smith</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Filters in any tool, programming language, software, etc. are one of those features which are crucial for everyday data work. I assume there is literally no data task that can be solved without using at least one filter. This applies to using Tableau too.</p><p>When speaking about Tableau filters, one of course first has in mind a filter shelf where one can put dimensions, measures, sets, or some other preferred fields. Then, based on different values and our preferences, we filter our data to a subset ready for further data analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/252/1*AGfZgASkRK599eK0e7KmSA.png" /><figcaption>Tableau Filter Shelf (Source: Own)</figcaption></figure><p>I guess most people who are somewhere at the beginning of their Tableau learning path (like I was as well) would stop at that point — put preferred fields into a filter shelf, select how you want data to be filtered, and done!</p><p>However, if you right-click on a selected filter, you will see there is an option <strong>‘Add to Context’</strong>.</p><h3><strong>How I Learned About ‘Context Filters’ the Harder Way?</strong></h3><p>Like probably in most data cases, learning goes the harder way. Instead of having some sort of curriculum to go through (is there even such a thing?!), I usually learn basics and then jump to some concrete project. Then, through constant attempts to realize my idea and/or solve bugs/issues, etc., learning happens along the way.</p><p>This learning approach of course has one big cavity — <strong>you usually don’t know what <em>else </em>you don’t know</strong>, except for what’s right in front of your eyes. In other words, you are pretty aware if you know to do something or not regarding the stuff you want to accomplish at the moment. If something doesn’t work as expected, some sort of error message will emerge. But for topics that you are not tackling at the moment, there is no feedback. And that was how I in the end had to learn more about Tableau’s context filters.</p><p>It was when I was doing some analysis in which I wanted to use a FIXED function to fix a particular calculation for each specific user.</p><p>However, when I used that user-level calculated field in a sheet, I got some unexpected results — my filters weren’t working as expected.</p><p>After spending some time on googling <em>‘why Tableau is behaving strangely’</em> (no, it wasn’t, it was just doing EXACTLY what’s been said to do!), I came across the following order of Tableau operations:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*RWQAWYmreshQAyimButcgA.png" /><figcaption>Source: Tableau’s Source of Order Operations</figcaption></figure><p>In short: <strong>fixed Levels of Details (LODs) have an ‘advantage’ over dimension and measure filters. BUT, context filters come before LODs!</strong></p><p>In other words, ‘standard’ filters don’t have an impact on LODs, but context filters do.</p><h3><strong>When to Use Which of the Two Filter Types?</strong></h3><p>Having a choice between filters with different ‘power’ is a <em>significant leverage</em>.</p><p>Let’s say you have a task to find out:</p><p>a) a share of customers per article from the year 2022 in the total customer quantity overall (for example from 2010 to 2022), and</p><p>b) a share of customers per article from the year 2022 in the total number of customers, but only customers who have purchased at least ones in Category A.</p><p>Having in mind an option of context filters, I would approach this task as follows:</p><ul><li>create a LOD of the fixed total customer quantity overall (let’s call it <em>‘LOD Total Customer Qty’</em>),</li><li>for the first part, I would create a calculated field of customer quantity (<em>COUNTD(CustomerID)</em>) divided by <em>‘LOD Total Customer Qty’</em> (let’s call this new field <em>‘Customer Share’</em>),</li><li>we put the <em>‘Customer Share’</em> field into the columns shelf, the <em>‘Article’</em> field into rows, <em>‘Order Date’</em> into the filter shelf, choose the year 2022, and done!,</li><li>for the second part, we just need to duplicate the previous sheet, then put <em>‘Category’</em> into the filter shelf and select <em>‘Category A’</em>. As you can assume, it will impact the results partially — it will have an impact on the <em>‘Article’</em> row (will select only articles from <em>‘Category A’</em>) and on relative customer quantity, but not on the second part of the <em>‘Customer Share’</em> calculation (<em>‘LOD Total Customer Qty’</em>). Now, the only thing we need to do is to right-click on the Category filter, click on ‘Add to Context’ and we’re done with the task!</li></ul><h3>More From the Same Author:</h3><ul><li><a href="https://medium.com/@dkondic/what-is-netflix-schedule-for-adding-new-titles-89b854f9bccd">When Netflix Adds New Titles the Most?</a></li><li><a href="https://medium.com/evolve/what-are-top-25-countries-per-alcohol-consumption-and-what-they-like-to-drink-81f7cac3a407">What Are Top 25 Countries Per Alcohol Consumption? And What They Like to Drink? 🍻</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d54a91236bb4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Do U.S. Citizens Prefer Real or Fake Christmas Trees? ]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/evolve/do-u-s-citizens-prefer-real-or-fake-christmas-trees-7805c9c99e61?source=rss-13bfc78745d1------2"><img src="https://cdn-images-1.medium.com/max/2600/0*UrDt5By7vaKpIaEr" width="3559"></a></p><p class="medium-feed-snippet">Here&#x2019;s what the data says!</p><p class="medium-feed-link"><a href="https://medium.com/evolve/do-u-s-citizens-prefer-real-or-fake-christmas-trees-7805c9c99e61?source=rss-13bfc78745d1------2">Continue reading on Evolve »</a></p></div>]]></description>
            <link>https://medium.com/evolve/do-u-s-citizens-prefer-real-or-fake-christmas-trees-7805c9c99e61?source=rss-13bfc78745d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/7805c9c99e61</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[christianity]]></category>
            <category><![CDATA[christmas]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[usa]]></category>
            <dc:creator><![CDATA[Dusan Kondic]]></dc:creator>
            <pubDate>Sat, 25 Dec 2021 18:31:37 GMT</pubDate>
            <atom:updated>2021-12-26T14:21:44.329Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[What Are Top 25 Countries Per Alcohol Consumption? And What They Like to Drink? ]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/evolve/what-are-top-25-countries-per-alcohol-consumption-and-what-they-like-to-drink-81f7cac3a407?source=rss-13bfc78745d1------2"><img src="https://cdn-images-1.medium.com/max/2600/0*MYbI7AwVJltG5pPs" width="6000"></a></p><p class="medium-feed-snippet">Beer, wine, spirits, or something else?</p><p class="medium-feed-link"><a href="https://medium.com/evolve/what-are-top-25-countries-per-alcohol-consumption-and-what-they-like-to-drink-81f7cac3a407?source=rss-13bfc78745d1------2">Continue reading on Evolve »</a></p></div>]]></description>
            <link>https://medium.com/evolve/what-are-top-25-countries-per-alcohol-consumption-and-what-they-like-to-drink-81f7cac3a407?source=rss-13bfc78745d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/81f7cac3a407</guid>
            <category><![CDATA[alcohol]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[evolve]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Dusan Kondic]]></dc:creator>
            <pubDate>Wed, 22 Dec 2021 10:39:48 GMT</pubDate>
            <atom:updated>2021-12-23T22:55:43.087Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[When Netflix Adds New Titles the Most?]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dkondic/what-is-netflix-schedule-for-adding-new-titles-89b854f9bccd?source=rss-13bfc78745d1------2"><img src="https://cdn-images-1.medium.com/max/2600/0*r9A4YJ-t32h03Jhw" width="2667"></a></p><p class="medium-feed-snippet">Or, when can you expect the next &#x2018;Netflix tsunami&#x2019;?</p><p class="medium-feed-link"><a href="https://medium.com/@dkondic/what-is-netflix-schedule-for-adding-new-titles-89b854f9bccd?source=rss-13bfc78745d1------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dkondic/what-is-netflix-schedule-for-adding-new-titles-89b854f9bccd?source=rss-13bfc78745d1------2</link>
            <guid isPermaLink="false">https://medium.com/p/89b854f9bccd</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[netflix]]></category>
            <category><![CDATA[business]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Dusan Kondic]]></dc:creator>
            <pubDate>Sun, 05 Dec 2021 20:33:01 GMT</pubDate>
            <atom:updated>2022-09-24T16:06:03.536Z</atom:updated>
        </item>
    </channel>
</rss>