How to count Insight objects with certain attribute values

Questions & Answers
,
1

Hi, I have a list of Insight Objects which have about 5 select attributes. These attributes have select options:

  • N/A
  • Later
  • Done

I want to create a graph that shows for each attrbute:

  • A count of objects that have value Done AND A count of objects that have value Later

Regards
Amir

2

Hi,

The select attributes must be selected for import for each object type in eazyBI. In my scheme, I have Some Field with select options for Business Services and Category object types:

image
image1708×1136 74.8 KB

Such selection creates separate dimensions for respective object types:

image
image1540×742 51.9 KB

To have the count of all objects with “Later” selection, I used the following formula:

([Measures].[Objects created],
 [Business Services Some field].[Later])
 +
 ([Measures].[Objects created],
 [Category Some field].[Later])

image
image1636×668 69.8 KB

Kindly,
Janis, eazyBI support

3

Thanks for reply Janis and sorry for my late reply. But I was more thinking of a table that shows the attribute distinction. Similar to:

image

Using your method above I had to manually add each Attribute + value as different columns. There must be a simpler way?

Regards