Table Widget / Perform expression on datapoint
I have a requirement. I want to Display numeric Values in Widgets into Alphabets. Any solution
manthena2020
Posted 2 years ago·Last reply 2 years ago
9 comments
I have a requirement. I want to Display numeric Values in Widgets into Alphabets. Any solution
Mike Moniz
·2 years agoWhat are you trying to do in general? Have an example?
manthena2020
OP2 years agoMy Datapoint has Value = 0 . I want it to Diasplay as Offline
LM User
·2 years agoI've never been able to do that. Would love to.
But if you do color bars and set the range somewhere outside the range of the datapoint, it'll highlight the whole cell. So if your datapoint can be 0 or 1, set the range -10 to -5 and set the color to be red if the value is equal to 0.
manthena2020
OP2 years agoI want 1 as red and 0 as green .Again it is completely filling the box. So I want them in Alphacharacters
LM User
·2 years agoMike Moniz
·2 years agoYeah, nothing built-in for that. Normally I would either put in note in the title of the widget or the column (like "0=offline") or have a text widget explaining specific columns and codes.
Another trick I use is the column's color bars so it makes it a bit more obvious. For example if 0=offline and 1=online, I would set the color bars for that column to have Red when current value is =0 and fiddle with the min/max values so it fills in the whole cell.
manthena2020
OP2 years agoI want that in Table Widget. Any possibility
LM User
·2 years agoLM User
·2 years agoYou mean you want to convert an ASCII value, as a number, into a character? No way to do that that I'm aware of. You could possibly script something in javascript in a text widget, but that'd be extremely hackey.