How AI Decision-Making is Improving Enterprise Outcomes
Blog
Share 
LOD (Level of Detail) Expressions in Tableau
17 October 2023 
Sumi S Types of LOD Expressions in Tableau
- FIXED
- INCLUDE
- EXCLUDE
There are three types of LOD expressions in Tableau:
FIXED: The FIXED LOD expression calculates values based on specific dimensions, regardless of the dimensions present in the visualisation. It creates a virtual level of detail for the calculation. For example, {FIXED [Category]: SUM([Sales])} would calculate the total sales for each category, irrespective of other dimensions used in the visualisation.
INCLUDE: The INCLUDE LOD expression calculates values at the specified level while incorporating the dimension(s) used in the visualisation. It allows you to aggregate data for a specific dimension while considering other dimensions in the visualisation. For example, {INCLUDE [Region]: AVG([Profit])} would calculate the average profit for each region, considering all other dimensions in the visualisation.
EXCLUDE: The EXCLUDE LOD expression calculates values at the specified level while excluding the dimension(s) used in the visualisation. It enables you to aggregate data for a specific dimension while ignoring other dimensions in the visualisation. For example, {EXCLUDE [Product]: SUM([Revenue])} would calculate the total revenue for each product, excluding any other dimensions present.
FIXED LOD Tableau Function
In Tableau, the FIXED Level of Detail (LOD) is the widely used function that allows you to perform calculations using specific dimensions, irrespective of the dimensions present in the visualisation. It creates a virtual level of detail for the calculation, providing precise control over your analysis's granularity.
Steps to Create a FIXED Level of Detail Tableau Function
In Tableau, the FIXED Level of Detail (LOD) function allows you to perform calculations using specific dimensions, irrespective of the dimensions present in the visualisation. It creates a virtual level of detail for the calculation, providing precise control over your analysis's granularity.
The steps to create the FIXED LOD function are as follows:
- • Create a calculated field. (This can be done by clicking on the drop-down next to the “Search” bar in the dimension pane or by selecting “Analysis” and selecting “Create Calculated Field”)
- • Type in the FIXED LOD Formula in the calculated field and drop the field into the view.
- • We can obtain the syntax of the FIXED expressions when we search for “Aggregate” functions in the calculated field.
Example
The following FIXED level of detail expression computes the sum of sales per region:
Beinex+ Tableau Offerings
Beinex has 100 years of combined experience in Tableau and is led by professionals who have successfully delivered Tableau projects in the region for large private and public sector organisations. Our team of Tableau-certified consultants are real-life Tableau business users passionate about Tableau and providing a world-class experience. In addition to providing sustainable analytics solutions, Beinex will help organisations to build superior data visual analytics capabilities internally through our bespoke training programs.
In Tableau, "Level of Detail" (LOD) expressions are a powerful feature that allows you to perform calculations at different granularities within your data. With LOD expressions, you can control the level at which an aggregation or calculation takes place, regardless of the visualisation's dimensions.
Related Articles
BEINEX CONSULTING WINS ALTERYX 2020 PARTNER OF YEAR AWARDS, MIDDLE EAST
Beinex Consulting has been awarded as the Alteryx 2020 Partner of the Year, Middle East at the Alteryx Partner Summit and Awards virtual event along with 15 other winners from North America, LATAM, and EMEA.
During the Alteryx Summit, ‘Your Road to Revenue’, Alteryx celebrated the achievements and commitment of their partners to the Alteryx business and its customers. Beinex Consulting was awarded on the level of engagement in the Alteryx partner program and its efforts around driving innovation, growing revenue, and empowering Alteryx customers to solve our world’s most pressing business and societal issues in the Middle East Region.
Selected among top Middle East Alteryx partners, Beinex demonstrated excellence in delivering end-to-end analytics transformation services that revolutionised multiple industries in the Middle East.
Beinex Consulting Founder and Managing Director, Indumon Das indicates further growth for the digital transformation organisation soon: “Beinex continues to make strategic investments to enhance our association with Alteryx and clients in major Middle East markets. This award is a recognition to our continuous growth strategy and focus to be the best Middle East partner”
“Through their ongoing pledge to the Alteryx Partner Program, our partners have demonstrated their commitment to helping Alteryx customers break down barriers and deliver game-changing insights.” – Josh Lewis, VP, Global Channels, Alteryx
About Beinex Consulting
Beinex is a digital transformation organization with a broad range of analytics modernization and training services. As a pioneer in analytics and cloud transformation, Beinex’s mission is to transform the way individuals and the organizations work with the data through innovation and experience. Beinex offers a broad range of robust and scalable business intelligence and analytics services to drive effective decision-making and create business value.
During the Alteryx Summit, ‘Your Road to Revenue’, Alteryx celebrated the achievements and commitment of their partners to the Alteryx business and its customers. Beinex Consulting was awarded on the level of engagement in the Alteryx partner program and its efforts around driving innovation, growing revenue, and empowering Alteryx customers to solve our world’s most pressing business and societal issues in the Middle East Region.
Selected among top Middle East Alteryx partners, Beinex demonstrated excellence in delivering end-to-end analytics transformation services that revolutionised multiple industries in the Middle East.
Beinex Consulting Founder and Managing Director, Indumon Das indicates further growth for the digital transformation organisation soon: “Beinex continues to make strategic investments to enhance our association with Alteryx and clients in major Middle East markets. This award is a recognition to our continuous growth strategy and focus to be the best Middle East partner”
“Through their ongoing pledge to the Alteryx Partner Program, our partners have demonstrated their commitment to helping Alteryx customers break down barriers and deliver game-changing insights.” – Josh Lewis, VP, Global Channels, Alteryx
About Beinex Consulting
Beinex is a digital transformation organization with a broad range of analytics modernization and training services. As a pioneer in analytics and cloud transformation, Beinex’s mission is to transform the way individuals and the organizations work with the data through innovation and experience. Beinex offers a broad range of robust and scalable business intelligence and analytics services to drive effective decision-making and create business value.
We are thrilled to recognize Beinex Consulting for being named Alteryx Middle East Partner of the Year!https://t.co/xwmp7HbsMp#TogetherWeSolve pic.twitter.com/4zic9mdlgD
— Alteryx (@alteryx) October 1, 2020
Tableau 2024.3: Advanced Features Redefining Data Analytics and Collaboration
Tableau Cloud Manager
Tableau Cloud Manager is an enhancement to Tableau Cloud that allows customers to create and manage multiple Tableau sites with centralized management of licenses and users. Tableau Cloud Manager simplifies the expansion and administration of your cloud analytics environment, helps ensure you meet governance and data residency requirements and introduces new administrative efficiencies. The highlights of Tableau Cloud Manager are: 1. Expand analytics across your organization with multiple Tableau Cloud sites Tableau Cloud Manager enables Tableau Cloud customers to create and manage multiple sites in a single deployment. Additionally, Tableau Cloud Admins can deploy these sites in the regions of their choice. This functionality is particularly beneficial for global organizations with geographically dispersed teams. By allowing for the establishment of region-specific sites, Tableau Cloud Manager enables tailored analytics experiences that cater to the unique needs and compliance requirements of every team in your organization. Your Tableau Cloud edition determines site limits: • Tableau Cloud (standard): up to 3 sites • Tableau Cloud Enterprise: up to 10 sites • Tableau+: up to 50 sites 2. Effectively manage multi-site deployments Tableau Cloud Manager acts as a layer atop your Tableau Cloud sites, offering centralized management features that help you scale your analytics operations. Customers who deploy multiple sites can manage sites and license users in one place, including granting users access to multiple sites without requiring distinct licenses for each site. 3. Enhance governance with a new Cloud Admin role Tableau Cloud Manager also introduces a new Cloud Admin role, a level above the traditional Site Admin. This allows for more flexibility in how your organization manages and governs your analytics environment based on your unique needs. A smaller organization may employ the same person as a Cloud Admin and a Site Admin. For larger organizations, your Cloud Admin could be someone in IT using higher-level administrative capabilities to implement more control and coordination across your Tableau Cloud sites.
Multiple External Identity Providers on a Site
You can now enable up to 20 identity providers on a single Tableau Cloud site. This feature allows administrators to offer secure access to external users, internal users, and partners. By using multiple identity providers, you can achieve site consolidation and simplify access for both internal and external users throughout the organization.
Table Viz Extension
Transform traditional reporting into visual analytics while addressing your users' needs. Tables are essential visualizations for analysts, allowing them to examine data as text and convey detailed information at a granular level. The Table Viz Extension, developed and maintained by Tableau, enables you to incorporate detailed tables and grid views into your dashboards for users who favor traditional reporting formats. You can load this new visualization type into your marks card, configure new columns by dragging fields onto the card, and interact with the table directly for customization.
Spatial Parameters
Tableau 2024.3 introduces the full Tableau experience for geospatial data with the support of Spatial Parameters. In addition to the standard parameter types (such as string and integer), authors can now choose a “Spatial” type. These parameters create rich, interactive dashboards that allow you to ask and answer questions about geospatial information. The Spatial type enables the parameter to capture spatial geometries—points, lines, and polygons representing locations, paths, and regions. With Spatial Parameters, end users can select individual points, which are then passed as input into calculations, facilitating dynamic behavior based on their selections. This functionality is similar to existing parameter behavior but is now extended to include spatial objects. Read more about spatial parameters: https://beinex.com/topics/spatial-parameters-enhancing-geospatial-analysis-and-adding-interactivity-to-your-maps/
Display Data Model for Published Data Sources
Gain a visual understanding of how tables within your data model are related to Published Data Sources. You can view the relationships between tables and fields in Tableau by simply clicking on the Data Source pane in a Tableau workbook. By enabling analysts to see and comprehend how tables in the data model are interconnected in Published Data Sources, they can confidently create accurate visualizations with a clear understanding of the data model's semantics.
Tableau Cloud App for Microsoft Teams
The new Tableau Cloud App for Microsoft Teams allows users to seamlessly integrate data-driven insights into their daily workflows, resulting in faster and more efficient decision-making. This integration enables real-time data sharing, making it easy for users to share their favorite Tableau dashboards and Pulse metrics without leaving Teams—in personal apps, messages, channels, and meetings. From there, they can analyze and share their insights in a message or channel. Pinned channel content is also available to explore in Teams meetings, providing a fully interactive experience. This promotes a more data-driven culture by ensuring everyone can collaborate effectively with access to the same data and analytics.
Image source: https://www.tableau.com/products/new-features
How Beinex Can Assist You
Beinex, a premier Tableau partner, offers sustainable analytics solutions to organizations and enhances their internal data visualization capabilities through customized training programs. Our team of Tableau-certified consultants consists of experienced Tableau business users who are passionate about the platform and committed to delivering an exceptional experience. Connect with us to embrace transformation: https://www.beinex.com/free-tableau-software/
TABLEAU 2020.2 – A NEW LOOK AT VISUAL ANALYTICS
Tableau has been one of the most popular data visualization and analytics tools among the business users in the last decade. With the new features it is even simpler to see and understand data. It is evident that Tableau is made with the intention of appealing to everyone, even those with very limited technical know-how.
As always, the new version of Tableau is also packed with a punch. There are over 25 new features over the Desktop, Online, Prep and Mobile versions of the tool. Here are a few of them, that would significantly change the way you use this incredible platform.
I have been using this tool since the release on 6th May 2020. After a week of using it, I am convinced that the changes are significant and extremely useful. This new version seems a lot smoother (yes, that is the feeling you get when you use it), even compared to 2020.1, which was released last quarter. I will be focussing on some of the changes in the first blog, that would give you an overview and help you get started with this.
1. Relationships
As a trainer on Data Analytics for the last three years, I have experienced one struggle. It is about explaining the concepts of ‘Joins’ to business users. They find it confusing to know when to use ‘left join’ and when to use ‘full join’. (IT users and students had very limited issues since they have learned these concepts). Challenges like duplicate / repeating records in one of the tables (one to many mapping) is definitely hard to tackle unless you master the concepts and other techniques. However, in Tableau 2020.2, it uses ‘Relationships’ which is a much simpler and easier concept to understand, and Tableau does the heavy lifting if you are unsure
In this version, you can create logical relationship with data, visually. Relationship creates aggregations when you build the visualizations, rather than joining them in the database. This means that you can forget worrying about having to keep the data in the same level of details and the complications that would arise if it is not. For those who are familiar with the tool, the visual difference itself is quite significant. As soon as you drag and drop the second and subsequent tables, a relationship line (‘Noodle’ is what Tableau named these lines) appears and makes it easy to define the connection.
Once you add the table, a pop-up box suggests the best connection, where you can define further details (Cardinality and Referential Integrity) if needed. You can also view each of the tables independently even after defining the relationship. All you need to do, is just click on the table. You can also use the existing concepts of Union and Joins as well. Below is a simple example using Sample Superstore data.
2. Metrics
Metrics is a concept that would appeal to the higher management and executives. This is an option where you can track all metrices of your interest in one place, despite of it being included in multiple Tableau workbooks. Instead of creating a ‘Master Workbook’ with all the metrics, which involved development and maintenance effort, we can now do it with a simple click. It will add the Metrics or KPIs to the main Project folder itself. In addition, you can also see the trend of that particular metric over the period when the data refreshes.
In the example below, I have one Project in Tableau Online, which has got multiple dashboards catering to different business areas. I am adding two metrics: the number of male employees in the organization, and the YTD Sales. Since the data is not refreshed, the timeline will be empty. Just check out how easy it is to add the Metrics to monitor it continuously and effectively.
3. Set Controls and Set Action Updates
While this might be described as a new feature, it, in fact, opens a whole new set of opportunities to interact with your visualizations. If I try to describe set Controls in Tableau 2020.2, it can be simplified as an option in which we can include or exclude elements in a set in a simple drop-down (similar to ‘Filters’). The addition or deletion or new values in a set can significantly change the way we see the data.
This means that the end user can perform a variety of analysis in the front end. Check out the video below.
Set actions also has got two new selection modes as well in the new version. Tableau 2020.2. Instead of only assigning the set values, Set Action can now add or remove values incrementally, by interacting with the marks.
Zen Masters ‘The Flerlage Twins’ have a blog that explains all the features in details about this new set action option. You can check it out.:
4. Other Changes
No Dimensions or Measures:
One of the noticeable differences compared to the previous version, is the absence of sections for Dimensions and Measures. While there is separation line, it is less distracting than the previous versions. It is not only the Dimensions and Measure that got combined, but also the section for Sets. In this version, when you add a Set it will be added as another field in the table, just like a calculated field. This also makes complete sense, since the Sets already have a separate icon to denote them, and it can be clearly understood before using it for any analysis. However, there is a separate section for Parameters.
Always on Search Bar:
Also, the Search bar is now always visible and cannot be hidden, unlike the previous version. I prefer this option since I almost always enable the search and never hides it afterwards. The Search bar sits comfortably in the space that is created when the titles for Dimensions and Measures are removed. In addition, when you type a field name after selecting any field, it automatically goes to that field despite of whether it is Measure or a Dimension. This is similar to us typing a folder or filename to find it in a Windows Folder Explorer.
No more ‘Number of Records’:
Another difference is the absence of ‘Number of Records’ field. This is now replaced with a non-editable and non-removable field: ‘Tablename (Count)’. Since the data is defined by relationship and not joined, there will be multiple such fields if you use multiple data sources. Similarly, when we choose ‘View Data’, there will be multiple tabs based on the number of data sources we use.
I have tried to show these in the image below.
5. Explain Data and Ask Data Improvements
There are significant improvements in these features in every version and this time is no different. Even with all the AI capabilities, there would be times when we want to take control. Explain Data in the new version gives you that extra control that was missing in the earlier version. Authors can now choose which fields to be included in modelling Explain data, giving you the option to input your business logic to it. Explain data also allows you analyse more than just one outlier in the latest version. However, this option seems to be missing for relational databases.
When it comes to Ask Data, you can now provide custom suggestions based on data roles. In addition, the synonyms applied for one field can be published to use across data sources. It also supports scripted data sources in the new version and has some improvements on enterprise controls.
As mentioned at the beginning, there are several other features in Tableau 2020.2. It would be extremely difficult to include all those in just one post. There are other changes like Recommendations on Mobile, Manual sorting of Favourites, publishing directly from the browser without having to open the dashboard on Tableau Desktop etc. and so on.
I hope you got an overview to some of the new features and want to explore more. Let us know your thoughts and how these features were beneficial to you.
As mentioned at the beginning, there are several other features in Tableau 2020.2. It would be extremely difficult to include all those in just one post. There are other changes like Recommendations on Mobile, Manual sorting of Favourites, publishing directly from the browser without having to open the dashboard on Tableau Desktop etc. and so on.
I hope you got an overview to some of the new features and want to explore more. Let us know your thoughts and how these features were beneficial to you.
Zen Masters ‘The Flerlage Twins’ have a blog that explains all the features in details about this new set action option. You can check it out.:
4. Other Changes
No Dimensions or Measures:
One of the noticeable differences compared to the previous version, is the absence of sections for Dimensions and Measures. While there is separation line, it is less distracting than the previous versions. It is not only the Dimensions and Measure that got combined, but also the section for Sets. In this version, when you add a Set it will be added as another field in the table, just like a calculated field. This also makes complete sense, since the Sets already have a separate icon to denote them, and it can be clearly understood before using it for any analysis. However, there is a separate section for Parameters.
Always on Search Bar:
Also, the Search bar is now always visible and cannot be hidden, unlike the previous version. I prefer this option since I almost always enable the search and never hides it afterwards. The Search bar sits comfortably in the space that is created when the titles for Dimensions and Measures are removed. In addition, when you type a field name after selecting any field, it automatically goes to that field despite of whether it is Measure or a Dimension. This is similar to us typing a folder or filename to find it in a Windows Folder Explorer.
No more ‘Number of Records’:
Another difference is the absence of ‘Number of Records’ field. This is now replaced with a non-editable and non-removable field: ‘Tablename (Count)’. Since the data is defined by relationship and not joined, there will be multiple such fields if you use multiple data sources. Similarly, when we choose ‘View Data’, there will be multiple tabs based on the number of data sources we use.
I have tried to show these in the image below.
5. Explain Data and Ask Data Improvements
There are significant improvements in these features in every version and this time is no different. Even with all the AI capabilities, there would be times when we want to take control. Explain Data in the new version gives you that extra control that was missing in the earlier version. Authors can now choose which fields to be included in modelling Explain data, giving you the option to input your business logic to it. Explain data also allows you analyse more than just one outlier in the latest version. However, this option seems to be missing for relational databases.
When it comes to Ask Data, you can now provide custom suggestions based on data roles. In addition, the synonyms applied for one field can be published to use across data sources. It also supports scripted data sources in the new version and has some improvements on enterprise controls.
As mentioned at the beginning, there are several other features in Tableau 2020.2. It would be extremely difficult to include all those in just one post. There are other changes like Recommendations on Mobile, Manual sorting of Favourites, publishing directly from the browser without having to open the dashboard on Tableau Desktop etc. and so on.
I hope you got an overview to some of the new features and want to explore more. Let us know your thoughts and how these features were beneficial to you.
As mentioned at the beginning, there are several other features in Tableau 2020.2. It would be extremely difficult to include all those in just one post. There are other changes like Recommendations on Mobile, Manual sorting of Favourites, publishing directly from the browser without having to open the dashboard on Tableau Desktop etc. and so on.
I hope you got an overview to some of the new features and want to explore more. Let us know your thoughts and how these features were beneficial to you.
Alation Data Catalog: The Key to Unlocking Effective Modern Data Governance
Challenges in Data Governance
Organizations often face challenges aligning with business goals to ensure data quality, security, and visibility. Alation's Data Catalog centralized data management and enhances accessibility, helping businesses address the data governance challenges by managing data in line with the policies and standards. Some of the challenges in data governance are as follows: • Issues in Data Quality: This happens due to incorrect or insufficient data in the system, which can result in expensive errors and affect decision-making. Enterprises must follow continuous monitoring to ensure high data quality and maintain trust in data assets. • Struggling with Data Silos: For effective data governance, organizations must break down data silos as the separate storing of data across departments could hinder data accessibility and sharing, resulting in inefficiencies. • Concerns about Compliance and Security: To avoid sensitive data breaches, organizations must comply with the regulations and standards and enforce strong security measures. Ignoring the compliance requirements can result in reputational damage, legal consequences, and hefty penalties.
More About Data Catalog
A Data Catalog is a warehouse of data assets that improves comprehension, governance, discovery, use, and management of data. It helps unify extensive and intricate data ecosystems into a single hub and breaks down silos, leveraging data the right way. The centralized view of enterprise data assets provided by the data catalog allows leaders to effectively drive cross-collaboration and scale data usage. Despite being a data repository, a modern data catalog assists in making business processes more data-driven. From enhancing operational efficiency to boosting customer experience to making strategic decisions, a data catalog is equipped to make the most of the data. A data catalog facilitates business decisions by letting people locate, understand, and trust the required data. Some of the fundamental functionalities and features of a data catalog are as follows: • Managing metadata: Brings together metadata from diverse sources into a centralized platform and offers a comprehensive picture of data across your enterprise. • Automating data discovery and search: Employs advanced search capabilities (search by tags, keywords domains, natural language, etc.), AI, and ML to locate and access relevant data assets. • Ensuring data quality: Allows data customers to understand data quality and build trust in the data through documentation of quality regulations, displaying data quality metrics, and quality profiling. • Tracking data lineage: Tracks the data flow from its source to destination, mapping the critical data aspects throughout the organization during the transformation. It also includes metadata about the transformation and data assets, enabling impact analysis. • Fortifying data governance: Enables data classification to assign suitable policies for ensuring compliance with regulations.
How Alation's Data Catalog Strengthens Modern Data Governance
Companies with data catalogs are more likely to acquire and retain customers and achieve profitability than those that do not have one. The following aspects elaborate on how Alation unlocks smarter data governance with its data catalog. • Breaking down data silos and centralizing data access: The Alation Data Catalog helps businesses struggling with data silos by centralizing data access and enabling easy data discovery and retrieval from a unified platform. Centralizing facilitates collaboration between departments by eliminating barriers between them. The enhanced collaboration enables effortless sharing of data assets and insights, fostering better decision-making and collaboration. • Managing metadata: Metadata management is paramount to data governance. With Alation Data Catalog, users can access powerful metadata management capabilities to handle data regulations, relationships, and definitions effectively. It allows users to understand and gain trust and confidence in their data assets. With features like end-to-end data lineage, automated metadata harvesting, and policy enforcement, Alation ensures data accuracy, accessibility, and compliance. • Enhancing data quality through Data Profiling and Cleansing: Data quality stays crucial for any organization to ensure trustworthy analytics and reporting. The Alation Data Catalog's data profiling and cleansing tools help detect inconsistencies and inaccuracies in data, helping enterprises maintain high data quality standards. • Guaranteeing compliance and security: With the Alation Data Catalog, compliance, and security can be ensured by implementing access controls and permissions. It entails protecting sensitive and confidential information by enabling the restriction of data access based on roles. • Fortifying data security: The comprehensive audit trails and monitoring offered by the Alation data catalog are important for data security as they facilitate tracking data usage and changes over time. It also helps identify possible breaches and unauthorized access, enhancing accountability and transparency across the enterprise. • Making progress through continuous monitoring: Conducting routine audits to evaluate compliance and data quality is vital for ensuring data governance remains effective and adaptive to the dynamic requirements. Alation Data Catalog's monitoring tools offer insights into the use of data and the likelihood of serious security breaches, enabling informed decisions about policy modifications. It is important for businesses to invest in training programs for data users as they help them understand the functions of data catalog and apply the best practices. With the Alation Data Catalog, businesses can promote collaboration and maintain data integrity and safety. Alation's holistic approach to data governance builds a trustworthy and accountable culture. The Alation Data Catalog functions as a powerful enabler, equipping enterprises to thrive in a data-driven world by streamlining complex governance tasks and promoting a culture of data literacy. In partnership with Alation, Beinex equips businesses with the support to fulfill data governance requirements while streamlining implementation and saving time. Connect with us for a demo: Beinex - Beinex: Your Trusted Alation Partner in Dubai, UAE, MEA, KSA & UK for Data Intelligence
The Agentic-AI-First Global Capability Centers: From Decision Support to Decision Execution
Fewer than 10% of enterprises have successfully scaled agentic AI; yet Global Capability Centers (GCCs) may be the one structural environment built to change that. According to McKinsey, nearly two-thirds of enterprises have already experimented with agentic AI, but the gap between experimentation and scale remains wide.