Do you want Solution as per below screen shot.
to make this you need to add min(1) in column only, for greater or less than 15 condition, you can write formula in if condition & place it in Color marks
just double click in Column and write min(1) then enter...!!!
Hope it will work for you, if not Please write back to me..!!!
Hi Swathi, I have seen this already but it doesn't fit in my situation.
but if you could help please share the .twbx file
Hello Alok, could you share the twbx file for better understanding?
Hello TG, I can't change the data type as actual source is not xls, this is just an example and end-user doesn't want to change the data at all. Still request you to share the twbx file.
If data type is the problem, then you can cast and update color formula as INT([Value])<=15.
find attachment twbx 10.1 version file in attachment.
i have Done Below points:-
1- Change dimension - Value from String to number
2- update formula color
if [Value] <=15 then 'Red' else 'Green' end
3- add min(1) in Column and get result as u desired hopefully
if you don't want to change Value format (String to Number) then use below formula to get the same result
if INT([Value]) <= 15 then 'Red' else 'Green' end
still stuck somewhere let me know..!!!
Hey Alok, Thanks for your reply.
But the issue here is I don't want to color the last column, I want to color the VALUE column itself. Hope I am clear.
Hello TG thanks for the reply, but again as I have replied, I want to color the Value column itself not the abc column.
3 of 3 people found this helpful
Hope Below Screenshot will help you. find attachment for the same
Still have any query let me know...
1 of 1 people found this helpful
There is no direct way to get the exact result which you want.
1. You need to use place holder method as discussed earlier by ALOK KUMAR SACHAN, however instead of just one field, you need to put all the fields after Value on individual placeholder and format the individual column.
for more about this concept you can visit
However in order to work with this trick you may need to use lowest granular level in the sheet as hidden field.
This method may get complex and very difficult for formatting based on types of columns you are trying to display.
2. Second approach is to create two sheets
One with columns till Values using same text card and formatting. Use another sheet with all columns with all columns before value including value column is hidden.
This approach would appear as you desire as long as there are less number of rows. With more number of rows you will see scroll bars of individual sheets.
3. Third option is to make Value as continuous and use it with Label marks card. Then you can use Highlight tables to your advantage.
I would personally suggest go with option 3 as it would be more efficient than other two approaches, as ultimate goal I assume to be highlight values.
everything applies except I have shown values > 15 instead of <15