Filter by attribute

Questions & Answers
1

Hello.
I have 3 object types in Insight:

  1. Color (attr: name)
  2. City (attr: name)
  3. House (attr: name, color, city)

House.color - link to object Color
House.city - link to object City
I want to build table:
Rows - City
Columns - Color
Measure - list of House names, separated with “;”

Maybe i should use Filter function? but i can’t make an expression

2

Hi,

Please check the following example with a similar configuration where Assets have link to the Model and owner. I want to create a table showing the list of assets by Owner and Model (Owner on the report rows, Model on the columns).

I imported both attributes as dimensions and added those dimension to the report:

image
image1618×900 56.3 KB

The default measures of Objects created shows the count of assets in each cell:

image
image2406×1066 275 KB

Now I need a custom formula for generating the list of assets:

Generate(
  Filter([Object].[Asset].Children,
  [Measures].[Objects created]>0
  ),
  [Object].CurrentMember.Name,
  ";"
)

image
image2568×800 231 KB

Kindly,
Janis eazyBI support