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.
Anonymous you can use a switch statement probably to derive it, however can you show me what your data looks like? otherwise it will be hard to show you how to write it
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