Hello everybody good morning, i am having an issue doing a Datediff
I have the next table
and doing this
DATEDIFF('minute',[Fecha de Compra] ,(if [Kpi]='prm:created_to_florist:orig' THEN [End] END ))
it sends 10,208 when the right answer is the difference between August 31 and September 1 which is like around 900 minutesl, why is this, I am attaching my workbook
there must be multiple rows that the sum (Proceso a florista) is aggregating. If you change it to lets say avg, then you get the proper number.
Thanks a lot!!!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...