Cell formatting on the basis of status

[rohit]

Hello,

Is it possible to do cell formatting on the basis of status in workflow.
Like i have 5 status New, In progress, test, done and closed.
When i transition a issue from new to in progress , the color of previous status should be yellow and current status should be green.

Regards,
Rohitkumar

[daina.tupule]

With eazyBI version 5.0 we introduced new functions to access Columns and Rows selections. While there are default formulas designed based on Rows functions (check add calculated) you can apply similar functions to Columns as well.

Here is an example formula to set value Yellow if an issue was in the status and is not moved back to any previous status. It will show value Green for current status:

CASE WHEN
[Measures].[Issues history] = 0
AND
SUM(
  Head(
    VisibleColumnsSet(),
    Rank(
      CurrentTuple(VisibleColumnsSet()), 
      VisibleColumnsSet())
      ),
  [Measures].[Issues history]) = 0
THEN
"Yellow"
WHEN
[Measures].[Issues history] = 1
THEN 
"Green"
END

You would like to use Transition status dimension in Columns. Please move Measures to Rows (do not use it on Columns) for better results to use new column functions.

Then click on Status calculated measure and set the cell formatting conditions: use Green or Yellow both in Min and Max conditions. I set the background and text color the same:

Here is my report:

Daina / support@eazybi.com