Loading

How to apply a filter on only one of the measures in the same worksheet

Дата публикации: Apr 13, 2024
Задача
How can I apply a filter to only one of the measures without influencing other measures in the same sheet?
 
Действия
  1.  Create a calculated field below
    • Order_LOD: { FIXED [Region]:COUNT([Orders])}
  2. Drag the [Region] to the Columns shelf and then [Order(Count)] as well as the created [Order_LOD] to the Rows shelf.
  3.  Now use category in filter and this will be applied to the [Order(Count)] not [Order_LOD]. It is because Fixed level of detail expressions compute values without reference to the dimension in the view.
Please find the attached sample workbook.
Дополнительные ресурсы
Tableau's Order of Operations
Номер статьи базы знаний

001470643

Вложения

demo.twbx

1201 KB

 
Загрузка
Salesforce Help | Article