Tiles dynamically change based on rank wise

Question & Answer
, ,
1

Hi Team

I have a once scenario like below

i need to develop my dashboard like

image

here lenovo,pristige,crompton,voltas is my brands
x axis is in disposition
y axis is value

i have filtered based on brand wise graphs

here i need to maintain brands rank wise

today like above image brand ranks are
lenovo=1
pristige=2
crompton=3
voltas=4

but tomorrow these ranks are changed right based on that ranks visuals are also need to change

can you please provide me any solutions for like above scnerios

thanks
b vinod kumar

1 Like
2

Hello @vinodkumarb, it seems like you will want to use a denseRank calculation and partition it by day so it would provide a new rank depending on the daily value associated with the brands.

One thing to note about rank, grouping in the visual will be important. You want to partition by day but not by brand, so it will give you a rank for the value of each brand daily. The function would look something like this:

denseRank(
  [sum({Value}) DESC], 
  [truncDate('DD', {Date})]
)

That should allow it to be dynamic by the day and you can group the aggregation by brand in the visual. I will mark this as the solution, but please let me know if you have remaining questions, and I can guide you further. Thank you!

3

Hi @DylanM

thanks for quick response,
Here my question is visuals need to change their positions dynamically,
with their allocated ranks

Thanks
B Vinod kumar

1 Like
4

Hello @vinodkumarb, at what scale would they need to dynamically change? This would give you a different rank per day. Is that not the level of granularity you are looking for? I need a little more information about what would dynamically alter the value being returned to guide you further.

5

I have created sample analysis please verifiy and get back to me if is there any solutions we have

test

thanks
b vinod kumar