Forum Discussion

walterdp's avatar
walterdp
Helper I
3 years ago
Solved

How to create a visual object with a dynamic information

Hi all I need to create a card with a text that will change based on the result of the calculation of the median of the time to restore. Let me give an example     The graphic shows the m...
Need Help
  • walterdp's avatar
    walterdp
    3 years ago

    Hi all:

     

    With the help of a team mate we found the solution and it was a very simple one (I feel very stupid by the way).

    Estados = IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=24, "Diario", 
IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=168, "Semanal", 
IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<= 720, "Mensual", "Anual")))

     

walterdp's avatar
walterdp
Helper I
3 years ago

Hi all:

 

With the help of a team mate we found the solution and it was a very simple one (I feel very stupid by the way).

Estados = IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=24, "Diario", 
IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<=168, "Semanal", 
IF(MEDIAN('Incs Cerrados (dic 2022)'[Tiempo Resolución])<= 720, "Mensual", "Anual")))