Solved

Filtering Views - When can you filter by properties?

  • 30 December 2022
  • 5 replies
  • 255 views
S
Rank
Userlevel 1
Badge +1
  • Sai Newly Minted Pigmenteer
  • Newly Minted Pigmenteer
  • 4 replies

Hi! For creating filtering views, why aren’t some dimensions allowed to be filtered by properties? For example, I have a dimension in my data hub for balance sheet accounts and some additional properties within that dimension, but I’m unable to filter by those properties. 

What I can do instead is add BS_Accounts → Property as a filter on the right-side bar, and restrict it to what I want to filter 

Filtering View unable to select “Property” for Dimension “BS_Accounts”:

 

Filtering “BS_Accounts” Via Pages in Sidebar and Restricting Dropdown List:

 

icon

Best answer by Sai 10 February 2023, 19:02

View original

5 replies

Matt D
Rank
Userlevel 3
Badge +4

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.

cRKl3Zhl_mirCJ1Ih63bL2RApb9JI_FIYQVX4MGpB_E2SOcAcOOcyUbadsMvvC2kSpFJeU6uxwAM5igftFZOc8W_Ap3CgeUaldneB45MjZXr1AseFUBsNvFZTJWIqAxNy_GV1zHSbQKYlbtBNZ1IxtwpTwxw91z1zOg8xQuTRECEvEUePL4aME4EPCSO8g

 

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

 

 

 

Hope this helps :)

Matt
KarlW
Rank
Userlevel 4
Badge +7

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

Karl (Customer Scaled Solutions Lead @ Pigment: ask me about community, academy, support, resources)
S
Rank
Userlevel 1
Badge +1

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.

 

Matt D
Rank
Userlevel 3
Badge +4

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
  1. The metric in which you want to apply the filter and the dimensions within it

Thanks

Matt
S
Rank
Userlevel 1
Badge +1

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

Reply


Ask your question here!

Terms & ConditionsCookie settings