Colors based on Buckets

[kulasekhar]

Hi All,

I have one requirement, I have Manger, Country, Employee, Expense/TransactionDate, Amount fields.

Now i have to generate unsubmitted amount based on Employee.

Current Date - Expense/TransactionDate = Days

Metrics -->  < 7 days (green); 8 to 30 days (Yellow) and >30 days red

I want to display Employees under Red/Green/Yellow buckets. For Example Days < 7 then that Employee should display in green color

i'm attaching sample QVW and Data file also

Could you please anyone respond on this

Thanks,

Sekhar

[m_woolf · Accepted solution]

I put the expression in the background color for the Country.