Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Index depending on column value

Hi,   I have this situation:   I created a conditional column that indexed my value. My problem is that I want this count restart depends on the week value and more i want to index my value...
Need Help
  • serpiva64's avatar
    serpiva64
    4 years ago

    From your table

    you group rows by week and by count (in order to manage situation of parity)

    hten you group by week

    then you order descending your column count inside your groups

    at this point you add and index column

    at this point you first expand Custom

    you obtain this

    Finally you expand AllRows.1 

    remove unnecessary column and that's done

     

     

     

     

     

     

     

     

     

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

Sorry i forgot to expand one column. You can do it in

and this is the final result

 

 

robertosangi's avatar
robertosangi
Helper I
4 years ago

serpiva64 just to close the question. 

I want to represent this in table. I wanted to insert the data you found in such way:

 

 

 

How can I do that in a table?
Thanks

  • serpiva64's avatar
    serpiva64
    Solution Sage
    4 years ago

    Hi,

    You can achieve something like this from your previous 

    Add acolumn with W-1

    Merge your query on itself

    Expand

    Change type then add difference column

    change type

    then you can create your matrix