Skip to main content

Hi,

 

So, I have a table, which contains four columns stating the status of four different tasks we do in our certain process: GIS1, GIS2, Mx1, Mx2. Values in those fields can be either 1 or 0 (representing task is done or task is not done yet) There are two other relevant column in my table, SA_VJ, which gives information if the task in question is of type FG SA or FG VJ, and Käyttöönotto, which is the date of commissioning.

 

I'd like to follow if those four tasks, GIS1, GIS2, Mx1 and Mx2 are done within time. For that I figured out I could do a calculated field called Tiedonsyötön_status that checks the status of those four status field and also takes into account whether certain deadlines (some calculated fields based on current date) have passed. Basically the code in this Tiedonsyötön_status field is almost never ending IF-statement with lots of outcomes that are texts describing the status. For those outcomes I wanted to give traffic light colors (green, yellow, red) to give a visualization of the status.

 

My problem is that although the slightly complicated IF-statement based code in Tiedonsyötön_status field should work, when I drag the field in Color (inside Marks shelf) I do not seem to be able to get more than four outcomes describing the status of our process out of more than ten. Why is this and how can I get all of the desired outcomes (or outputs) from my calculated field?

 

Here's a picture which probably helps to understand my question:

 

Calculated field (giving user the status of a process) with more than four outcomes, why four seems to be the upper limit of outcomes?

3 answers
  1. Nov 18, 2017, 7:05 PM

    Hi Ari,

     

    Just to get the conversation started;) Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.

     

    Hi Ari, Just to get the conversation started;) Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread. 1.

     

    1. Tiedonsyötön_status:

     

    IF [GIS1]+[GIS2]+[MX1]+[MX2]=4

    and [Käyttöönotto]<=today() then 1

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=3

    and [Käyttöönotto]<=today() then 2

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=2

    and [Käyttöönotto]<=today() then 3

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=1

    and [Käyttöönotto]<=today() then 4

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=0

    and [Käyttöönotto]<=today() then 5

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=4

    and [Käyttöönotto]>today() then 6

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=3

    and [Käyttöönotto]>today() then 7

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=2

    and [Käyttöönotto]>today() then 8

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=1

    and [Käyttöönotto]>today() then 9

    elseif [GIS1]+[GIS2]+[MX1]+[MX2]=0

    and [Käyttöönotto]>today() then 10

    END

     

    2. Drag the required objects to the indicated locations.

     

    pastedImage_1.png

     

    Regards,

    Norbert

0/9000