I have calculated field as 'Average Time Spent.' Now I want to use that field as a filter in Discover or as a filter in other formulas.

Nandita_Gupta
yesterday
3replies
Answered

I have calculated field as 'Average Time Spent.' Now I want to use that field as a filter in Discover or as a filter in other formulas. is this possible without writing anything in data model

- VP Product Management
- Ian_Macdonald
- 11 hrs ago
- Reported - view
Hi

When you say "calculated field", is this as a new virtual column in the underlying table, a calculated Measure or a custom member in a hierarchy?

Thanks.

Ian
- Nandita_Gupta
  
  11 hrs ago
  
  Reported - view
  a calculated measure
- VP Product Management
- Ian_Macdonald
- 11 hrs ago
- Reported - view
Hi

For quick filtering, simple drag and drop the calculated Measure into the filter Drop zone. As you hover over the drop zone, you will be presented with a number of quick filter options. Choose which one you want and drop:

For further guidance on how to filter using values, please see our Help page on value filtering and also the page discussing the Filters drop zone in general including numeric vs slicer filters.

Hope that helps!

Ian