Provide different colors based on values in the report- EazyBi

[Prameesha Samarakoon]

Hi,

Is it possible to change a colour based on the cell value of a report? As in, say in a report the values greater than 5 should be coloured red. Selecting a colour is possible in pie , line and other forms of charts but is it possible in the tabular format as well?

Thanks

[Raimonds Simanovskis · Accepted solution]

Currently it is not possible to do this in eazyBI but it is planned to add such conditional formatting (changing color or bold font) in one of the nearest eazyBI versions.

[Angus Law]

@Raimonds Simanovskis - any update on this?

[Raimonds Simanovskis]

@Angus Law It is possible to do conditional formatting in eazyBI reports now - this was added already in 2014 https://docs.eazybi.com/display/EAZYBIJIRA/Changelog#Changelog-2.2.0/ReleasedJuly17,2014

[Angus Law]

Thanks! Apologies for not investigating myself 

[Raimonds Simanovskis]

@Angus Law No problems, I'm glad to help  Please contact support@eazybi.com if you need more detailed help with reports you are building.

[Pablo Scheri]

Hi @Raimonds Simanovskis, will it be possible to change colors based on a comparison between two cells? ex: if hours spend > than original estimated then mark it as red.

Thanks!

Edit: and also because of a conditional between a row and a column? Ex: if user spends more than 10hours in project B, mark it as red.

[Raimonds Simanovskis]

Hi Pablo,

You need to create an additional calculated measure which will calculate the difference between hours spent and the original estimate and then you can do conditional cell formatting for this calculated measure. Please contact support@eazybi.com if you need help with such calculated measure.

Kind regards,
Raimonds

[Pablo Scheri]

Hi Raimonds thank you for your reply, I will do that. Regarding complex row and columns comparison, is there any easy way to do it?

Regards,

Pablo.