Level of Detail expressions in Tableau allows us to create complex calculations. It is useful for using dimensions from different levels with aggregation. It enables us to use data from different granularities at the same time. LOD expressions can be created with this format;
Relational databases enable users to store and retrieve data from related tables(1). They compose of tables, rows, columns, keys, atomic data, and relationships between tables. There are three types of relationships in these databases;
· One to One (1:1)
Example: In nature, each element has one formula and each formula represents one element.