Forum Discussion
Show Most recent comments
Hi jcastr02 ,
That is not possible on the table visual as a workaround you can:
- Create a button with no backgroud and no line
- Make the button the size of the column header and place it on top of the header
- Group the table with the header
That way you will still see the header of the table but if you click on it won't be reorder.
Hi jcastr02 ,
Best option is what you have done in your visualization so placing the comment and index on your table then turn off wrap text on title and sort the table by index then just hide the index column by reducing it's size.
A workaround but it works.
MFelix Yes ! this seems to work! I appreciate the help. Only thing I noticed that repeating items such as N/A, pay, the hours, etc. are pushed to the top so everything else sorts except the repeating items, any work around you are aware of?
Hi jcastr02 ,
Make the summarization of the index column the miminum value and then sort it out. what is happening is that the default behavior of ID is to sum values since you have more than one values for certain comments they get to different positions based on its sum.
If you select minimum you will get the first value of the index.
for example NA in your table is giving the 299 (sum of several index) making it to minimum it gives 17 if you go to your table the first record with NA is line 18 at 17/01/2020 so the first one as you want.
MFelix You are awesome that worked! One last ? How can I hide the sorting arrow. From end user perspective if they click on the visual, it will sort by Value again
Hi jcastr02 ,
That is not possible on the table visual as a workaround you can:
- Create a button with no backgroud and no line
- Make the button the size of the column header and place it on top of the header
- Group the table with the header
That way you will still see the header of the table but if you click on it won't be reorder.