EXPRESSION WITH CONDITION

[eloisateixeira]

Hey qliker's, i need a help.

I want to make an expression with some conditions. I want the average number of days spent in a patient in hospitalization, before and after entering monitoring to make a comparison and see if there was an increase or decrease in the days of hospitalization.

For example:

Before: if DATE_HOPITALIZATION and DATE_DISCHARGE < (smaller than) DATE_MONITORING, show me the average of days in hospitalization (DATE_DISCHARGE - DATE_HOSPITALIZATION),

After: if DATE_HOPITALIZATION and DATE_DISCHARGE > (bigger than) DATE_MONITORING, show me the average of days in hospitalization (DATE_DISCHARGE - DATE_HOSPITALIZATION)

[Wlad_Masi · Accepted solution]

Hi @eloisateixeira,

This may work. 
Something to be aware of is when using the and in comparison you have to split it in two.
(If comparison or/and other comparison)

If(DATE_HOPITALIZATION < DATE_MONITORING AND DATE_DISCHARGE < DATE_MONITORING, sum(DATE_DISCHARGE - DATE_HOSPITALIZATION))

[Kushal_Chawda]

@eloisateixeira  Where you want to show this number? I mean which chart? What are the dimensions ?