https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199748#M12505 <P>I think I see. The thresholds are defined differently for each row, so some of the values that are red for one row are only orange for another. </P> <P>It would be extremely difficult and involve some custom code to make clicks on the "head1" and "head2" columns sort by the colors instead of the values. However you could allow the hidden threshold value (or whatever it's called) to not be hidden, but rather to be exposed in the table. Then the user could click it, and if you could rearrange it so that the values were "red" "orange" and "green", it might give your users what they want? </P> <P>Or alternately you could just do the <EM>default</EM> sort by the threshold field when the table is first rendered.... Then if they change the sort order by clicking the little arrows they wont have a way to get that sort order back but maybe that's OK. </P> Fri, 28 Mar 2014 16:49:52 GMT sideview 2014-03-28T16:49:52Z https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199745#M12502 <P>Hi,<BR /> I have a advanced XML dashboard, where I display a table using search command. I have used side-view utils to color the table cells based on some threshold values. I can see a sort arrow beside every column header which sorts the table based on values. Is it possible to utilize this sort arrow to sort the column on basis of color.</P> <P>my dashboard table is as shown below:-</P> <P><IMG src="http://answers.splunk.com//storage/image1.png.png" alt="alt text" /></P> <P>I want the table to sort as red on top, den orange den green irrespective of their value on click of sort arrow.</P> <P>Please Help...!!!</P> Thu, 27 Mar 2014 09:59:51 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199745#M12502 harshal_chakran 2014-03-27T09:59:51Z https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199746#M12503 <P>Isn't the color based on value? If yes then sorting by values is same as sorting by color.</P> Thu, 27 Mar 2014 13:53:05 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199746#M12503 somesoni2 2014-03-27T13:53:05Z https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199747#M12504 <P>yeah, the color are based on values. But here, each cell has a color based on different values. therefore, I want to sort it based on colors irrespective of values.</P> Fri, 28 Mar 2014 06:19:11 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199747#M12504 harshal_chakran 2014-03-28T06:19:11Z https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199748#M12505 <P>I think I see. The thresholds are defined differently for each row, so some of the values that are red for one row are only orange for another. </P> <P>It would be extremely difficult and involve some custom code to make clicks on the "head1" and "head2" columns sort by the colors instead of the values. However you could allow the hidden threshold value (or whatever it's called) to not be hidden, but rather to be exposed in the table. Then the user could click it, and if you could rearrange it so that the values were "red" "orange" and "green", it might give your users what they want? </P> <P>Or alternately you could just do the <EM>default</EM> sort by the threshold field when the table is first rendered.... Then if they change the sort order by clicking the little arrows they wont have a way to get that sort order back but maybe that's OK. </P> Fri, 28 Mar 2014 16:49:52 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sort-the-table-on-the-basis-of-color-on-sort-arrow-click/m-p/199748#M12505 sideview 2014-03-28T16:49:52Z