Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Health Checking Applications

I have a CSV that has columns for Application, ServerName,Color.     Application  ServerName Color APPL1 ABCPMAPP01 GREEN APPL1 ABCPMAPP02 GREEN APPL1 ABCPMAPP03 AMBER APPL2 ...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Anonymous 

    I created the following measure, add the Application and the folliwng measure:

    App Status = 
//GREEN, YELLOW, AMBER, RED. 
VAR __Colors = VALUES( Table08[Color] )
VAR __Red = "RED" IN __Colors
VAR __Amber = "AMBER" IN __Colors
VAR __Yellow = "YELLOW" IN __Colors
VAR __Green = "GREEN" IN __Colors

VAR __Result = 
    SWITCH(
        TRUE(),
        __Red, "RED",
        NOT __Red &&  __Amber , "AMBER",
        NOT __Red && NOT __Amber && __Yellow , "Yellow",
        NOT __Red && NOT __Amber && NOT __Yellow , "Green"
    )
RETURN
    IF( 
        ISINSCOPE( Table08[Application ] ),
        __Result
    )

     



Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

Sorry, your question isn't clearn enough, please explain with the expected result.


  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Sorry Fowmy, I should of provided that. What I am looking for is some way to display a chart on a Dashboard in a Stacked Bar Chart where the Application Name is one item and the worst color the second part.

    APPL1            AMBER

    APPL2            RED

    APPL3            RED

     

    I have about 200 applications and each of those applications can have 1 to 200+ servers associationed with it and each of those servers could have any of the 4 colors associated with them. Example, if the server has Windows 2012 R2 as the Operating system on it then the color is RED and the Application is RED because it is on unsupported hardware. All the other servers could be GREEN but 1 RED makes it a RED. Let me know if this provides enough information.

    Thank you for replying.

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      Anonymous 

      I created the following measure, add the Application and the folliwng measure:

      App Status = 
//GREEN, YELLOW, AMBER, RED. 
VAR __Colors = VALUES( Table08[Color] )
VAR __Red = "RED" IN __Colors
VAR __Amber = "AMBER" IN __Colors
VAR __Yellow = "YELLOW" IN __Colors
VAR __Green = "GREEN" IN __Colors

VAR __Result = 
    SWITCH(
        TRUE(),
        __Red, "RED",
        NOT __Red &&  __Amber , "AMBER",
        NOT __Red && NOT __Amber && __Yellow , "Yellow",
        NOT __Red && NOT __Amber && NOT __Yellow , "Green"
    )
RETURN
    IF( 
        ISINSCOPE( Table08[Application ] ),
        __Result
    )

       



      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank you Fowmy, that worked perfectly.