Hi Sai,

Using the filter button near the top of the view for a metric or a table allows you to filter based on the dimensions “viewable” in that table. In the screenshot below, I am filtering in a metric dimensioned by Employee and Month.

However, in the Employee dimension, I have Entity as a property. I can add ‘Entity’ to the view in the pivot/configure data panel on the right. Note that I have added it into the rows; the property dimension must be in either the rows or the columns to be used as part of a filter.

If I now hit the filter button near the top, I have the ability to filter on ‘Employee > Entity’.

Hope this helps :)

Hi @Sai - just checking to ensure you have what you need on this now? Let us know if not!

Thank you for following up. In the below screenshot you provided, wouldn’t you be able to select “Property” in the drop down where it says “Items” instead of adding the property to the view? 

However, I don’t have that option in the below even though BS_Accounts has several properties in the dimension.

Hi Sai,

To help me understand your issue, can you please send two screenshots showcasing the following:

1. Your BS_Account dimension list and properties within it

2. The metric in which you want to apply the filter and the dimensions within it

Thanks

Hi Matt - I spoke with Keiran from support on this. Seems like the table I was using had a bug that prevented me from using the BS_Accounts properties to filter by. We did a workaround by moving around the BS_Accounts dimensions within the visible rows. Once the bug is fixed, this should no longer be an issue.

Thanks,
Sai