Count rows from data type "text" with the same content of two columns

[EmPi]

Hi everybody,

I want to count the rows (of data type "text") where two columns of a row have the same value. In the end I want to visualize how man releases are counted in the list and how it is allocated to the assignes.

Input Tabele

Result

I´am thankful for every hint.

Greetings
EmPi

[EmPi]

Thank you for the fast answers!

[Anonymous · Accepted solution]

@EmPi  Simple Enough.

1.  Use matrix visual.
2. Drag Release Column on Rows
3. Drag Assignee Column on Rows
4. Drag Assignee Column on Values , Right Click and Change Summarization to Count.

See below.

hope this helps.

Thanks

[harshnathani]

Hi @EmPi ,

You can try the above and then 

Turn off “Stepped layout to get the visulaization you want.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@EmPi , Not clear, Diaply issue or measure issue

refer

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/