Table Widget / Perform expression on datapoint
I have a requirement. I want to Display numeric Values in Widgets into Alphabets. Any solution
manthena2020
9 comments
I have a requirement. I want to Display numeric Values in Widgets into Alphabets. Any solution
Mike Moniz
What are you trying to do in general? Have an example?
manthena2020
OPMy Datapoint has Value = 0 . I want it to Diasplay as Offline
LM User
I'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
OPI want 1 as red and 0 as green .Again it is completely filling the box. So I want them in Alphacharacters
LM User
Mike Moniz
Yeah, 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
OPI want that in Table Widget. Any possibility
LM User
LM User
You 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.