topic Re: Need to color code cells based on Year Range in Search the Community

Need to color code cells based on Year Range

sdmech81 — Mon, 08 Nov 2021 10:04:32 GMT

HI,

We have data like below (sample data )

The expected results is as below: (We need to color fill based on condition the background in Table using above data.)

looking for working solutions. Thanks

AshutoshBhumkar — Mon, 08 Nov 2021 10:59:36 GMT

Hello,

Maybe below sample will help.

Table:
Load * Inline [
ID, Start, End
ABC,2020,2024
PQR,2022,2027
LMN,2025,2030
ABC,2026,2030
];

NoConcatenate
Table2:
Load
ID,
Start + IterNo() - 1 as StartEnd
Resident Table
While IterNo() <= End - Start + 1 ;
DROP Table Table;

Exit Script;

Output:

Row : ID

Column : StartEnd

Values : Count(StartEnd)

Background Color of Values : If(Count(StartEnd)>0,Blue())

Thanks,

Ashutosh

sdmech81 — Tue, 09 Nov 2021 08:52:28 GMT

Thanks ..its works