color on cell

[capriconuser]

i have table like this

e.g.

employeename   dates 20/3/2017  21/3/2017 22/3/2017 23/3/2017

abc employee                 5:00               5:00     5:00                    -

defemployee                        -                 5:00     5:00                    -

xyz employee                    5:00                  -       5:00                    -

now here i want to try if all employees has '-' on then want to color  beacuse on 23 suppose to be official holiday

this is i try but not works ..

=if(count({<AbsentFlag = {'Absent'}>}ZID) = $(vTotalEmp),RGB(0,0,255))

this fill cells where they found absent where as i want when all employees have absent then want to color on that specific date not all dates

[capriconuser]

any updated please?

[vishsaggi]

Can you share your sample app where you trying this expression?

[Anil_Babu_Samineni]

Create one field in Script

If(Len(Measure)>0, 'Present' , 'Absent') as Color_Flag

And use this?

=if(count({<Color_Flag = {'Absent'}>} ZID) = $(vTotalEmp),RGB(0,0,255))

[petter]

This should work for you using a Pivot Table:

[palanimurugan]

Hi..

There are 2 ways we can change the color.

        1. You can set the color using visual Cues Option. Please refer the snapshot.

        

         2. Goto View---> design gord--> right click on your desired cell-->select custom format cell --->then select the color

[capriconuser]

@petter-s yes this is i have sample data but here i only want red color on 23 .3.2017 like when all are absent then want to red else blue ... beacuse in other columns some are absent and some are present ..

[vishsaggi · Accepted solution]

Try this in your background expression like :

extending peters script

Load this.

ColorCode:
CrossTable(Date, Values, 1)
LOAD * INLINE [
employeename,20/3/2017,21/3/2017,22/3/2017,23/3/2017
abcemployee,5:00,5:00,5:00,-
defemployee,-,5:00,5:00,-
xyzemployee,5:00,-,5:00,-
];

Pivot table

Dim: Employeename, Date

Expr: Values

Background expr for Values like below

[capriconuser]

what is expression ?? if i am not wrong i did not see any expression

[capriconuser]

any update