1 of 1 people found this helpful
It's always good to share some sample data or a workbook if you really want help. If [Tempo de Toque] is date time format then you should not be using "". Check out the ISNULL function in Tableau. You are also likely to need DATEPART and DATEADD.
Hi Ivan, thanks to answer my question..
The data is like this:
Tempo na fila: 00:01:36 (minutes and seconds)
Tempo de toque: 0:00:05 (just seconds) the translation in english is: TIME RINGING on telephone to be exactly
I need to do the calculation:
IF tempo de toque = 0 or null (empty), THEN tempo na fila=0
I take the SUM and i do SUM-1
If this calculation >=11 then this call is ("abandonada") missed call, in english.
Could you post a few rows of your data? And is the format of [tempo de toque] and [tempo na fila] text?