Forum Discussion

NKotak_Leecare's avatar
NKotak_Leecare
Icon for Helper III rankHelper III
3 years ago

Measure for conditional formatting a card which displays count of incidents

Hi all,   I am looking to create a measure that I can use in conditional formatting of the accent bar to change color based on the incident value of the current month and the previous month. It sho...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
NKotak_Leecare's avatar
NKotak_Leecare
Icon for Helper III rankHelper III
3 years ago

Thanks!

 

how are you getting [lastMonth]?

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Hi NKotak_Leecare 

 

You can do:

last Month= CALCULATE([IncidentSavesInSelectedInterval],PARALLELPERIOD([Date],-1,MONTH))
  • NKotak_Leecare's avatar
    NKotak_Leecare
    Icon for Helper III rankHelper III
    3 years ago

    Hi mlsx4 

     

    Thank you! I tried using that measure but it is returning Red regardless of the count values. Do you have any idea why it is doing that and how can I resolve it?

    • mlsx4's avatar
      mlsx4
      Icon for Memorable Member rankMemorable Member
      3 years ago

      Hi NKotak_Leecare 

       

      Have you checked which value returns each of your measure separately?