Forum Discussion

Pri26's avatar
Pri26
Regular Visitor
2 years ago

Row-Wise Ranking of Values

Hello everyone! I'm working with a matrix visual and trying to create a measure that allows me to rank values row-wise. My data is hierarchical with 2 levels. I want the ranks to dynamically upd...
AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
2 years ago

Hi,

Not easy to help you, without more information, but at least I can give you some hints.

Functions like HASONEFILTER or HASONEVALUE should help you to know if your are on a detail level (level 2) or on a main level (Metric).

HASONEFILTER(Level2), should returns true on detailed lines and false on main lines.

As soon as you know that, you can add up an IF or SWITCH function, to make a calculation or another one, depending on your position (main or detail row).

I hope it's clear enough... for you, to use in your poject ?

Let us know

Pri26's avatar
Pri26
Regular Visitor
2 years ago

Matrix Visualraw dataset sample

Thanks for the suggestion AilleryO .

I attempted to address this issue but wasn't successful. For a clearer understanding, I've provided screenshots showcasing the data and the visual I'm working on. I have hierarchal row values within a matrix visual, and the date is presented in columns. My goal is to rank the values horizontally, row by row.

I hope this explanation is clearer.