Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a dashboard in a semaphore/trafic light style.
My source data is:
Project | Status |
---|---|
Project 1 | -1 |
Project 2 | 0 |
Project 3 | 1 |
Note: -1 is Red, 0 Yellow and 1 is Green
My script:
LOAD
"Project Code",
"Status"
FROM [lib://Projects/projects.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Milestones);
I want to build a dashboard, which would represent my status values in a trafic light, such like this:
Thank you,
FC.
In table, For Status Column , instead of using any image you can set background color to give colors to display it as Traffic light
Hi
See if attached will help you.
SCRIPT
NoConcatenate
EmpData:
LOAD *
FROM
[..\Data\Test6.xlsx]
(ooxml, embedded labels, table is Sheet1);
Images:
BUNDLE LOAD * INLINE [
ImageID, Path
Red, ..\Data\Red.png
Green, ..\Data\Green.png
Yellow, ..\Data\Yellow.png
];
EXPRESSIOn
=If(Status=-1,'qmem://ImageID/Red',
If(Status=0, 'qmem://ImageID/Yellow',
If(Status=1, 'qmem://ImageID/Green')))
Regards,
Vijay
In table, For Status Column , instead of using any image you can set background color to give colors to display it as Traffic light
Thank you for your usefull response.