more new tags

There needs to be a mechanism to remove duplicates from results. This becomes useful for determining the number of unique items in a column. For instance, an Order dimension with a column for customers has numerous customer IDs. In fact, for repeat customers, the column has numerous duplicate customer IDs.

(GRML) Blog Title
(GRML) Blog Date
(GRML) Blog Size
(GRML) Blog Company
(GRML) Blog Category

(GRML) Blog Title
(GRML) Blog Date
(GRML) Blog Size
(GRML) Blog Company
(GRML) Blog Category

To find out the number of individual customers, a DISTINCT tag is used. For a specific column, in a dimension, it gives the number of unique items.

(GRML) Blog Title

(GRML) Blog Date
(GRML) Blog Size
(GRML) Blog Company
(GRML) Blog Category

(GRML) Blog Title
(GRML) Blog Date
(GRML) Blog Size
(GRML) Blog Company

(GRML) Blog Category

Since there is no enforcement of data constraints on individual result items, a UNIQUE tag has a use. It only displays one result, if more than one identical result exists. This is unnecessary in a normalized set of data. However, without data constraints, this tag has a potential place.