Forum Discussion
Dynamically group
Hi Anonymous,
I would suggest that you create a table with only the creator names. This can be done by clicking Create Table and enter the following formula:
Creators = DISTINCT(Reports[Creator])
(assuming your table is called Reports.) Now establish a relationship between Creators and Reports on the Creator field.
Next step is to define a calculated new column called Group in the Creators table:
Group = VAR C = Creators[Creator] RETURN IF(CALCULATE(COUNTROWS(Reports),Reports[Creator] = C)/COUNTROWS(Reports) > 0.05,
C,
"Other")In your table visual you can now use Creators[Group] instead of Reports[Creator] and you should get the desired result.
Hi Vanessa,
My data look like that
I have the creator name, the date of creation and the raport title
I would like to group C and D because they produce less then 5% of the report total
Hi Anonymous,
I would suggest that you create a table with only the creator names. This can be done by clicking Create Table and enter the following formula:
Creators = DISTINCT(Reports[Creator])
(assuming your table is called Reports.) Now establish a relationship between Creators and Reports on the Creator field.
Next step is to define a calculated new column called Group in the Creators table:
Group = VAR C = Creators[Creator] RETURN IF(CALCULATE(COUNTROWS(Reports),Reports[Creator] = C)/COUNTROWS(Reports) > 0.05,
C,
"Other")
In your table visual you can now use Creators[Group] instead of Reports[Creator] and you should get the desired result.
Perfect, thank you very much