{"id":135,"date":"2024-10-02T02:59:01","date_gmt":"2024-10-02T02:59:01","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-3-data-filtering-and-sorting\/"},"modified":"2024-10-10T02:38:08","modified_gmt":"2024-10-10T02:38:08","slug":"chapter-3-data-filtering-and-sorting","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/essentialsofdatavisualizationwithtableau\/chapter\/chapter-3-data-filtering-and-sorting\/","title":{"raw":"DATA FILTERING AND SORTING","rendered":"DATA FILTERING AND SORTING"},"content":{"raw":"
\r\n\r\n\r\n\r\n\r\n
\r\n
\r\n
\r\n

\"image\"<\/p>\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n

\r\n
\r\n

By the end of this chapter, readers will be able to:<\/p>\r\n\r\n

    \r\n \t
  • Filter data based on the dimension, measure, or date fields<\/li>\r\n \t
  • Use the parameter feature to dynamically filter data<\/li>\r\n \t
  • Sort data effectively<\/li>\r\n<\/ul>\r\n<\/div><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/a>Filters<\/strong><\/h2>\r\n

Filters can be used to control the degree of information depicted in a visualisation. In other words, users can include and exclude the type or level of information displayed in a visualisation, allowing a focused investigation. Filters also allow users to make certain comparisons for decision-making purposes, e.g., comparison between a selected range of dimension members, comparison across a selected range of periods etc.<\/p>\r\n

A filter dialogue box appeared immediately once the users dropped a field to the F<\/strong>ilter<\/strong>s<\/strong> shelf. This dialogue box permits the users to set the characteristics of the filter. The available characteristics in each dialog box vary according to the type of field dropped to the filter shelf i.e. dimension, measure, or date field. The figure shows the summary of filter characteristics according to each field type.<\/p>\r\n

\"\"<\/p>\r\n\r\n

<\/a>Filtering <\/strong>B<\/strong>ased on <\/strong>a D<\/strong>imension <\/strong>F<\/strong>ield<\/strong><\/h2>\r\n

When a dimension field, is dropped to the filter shelf, a dialogue box pops out, with each tab in the dialogue box representing a characteristic that the user can set to the filter:<\/p>\r\n\r\n