History for Dashboard StreamlineToQliksense · Genomma-Lab-Internacional/businessintelligence Wiki

[Item code] as [materials-Item code], [BU] as [mBU], ApplyMap('MarcaMapping',[Marca]) as [mMarca], [Supplier] as mSupplier, "Nal/Exp" as "mNal/Exp", Comprador as mComprador, if([Jun 2021] * 0.85 > [Jun 20213],'Volúmen menor al solicitado', if([Jun 2021] * 1.15 < [Jun 20213],'Volúmen mayor al solicitado', 'Volúmen igual al solicitado')) as mValidacion, "Compra Directa" as "mCompra Directa", "On hand" as "mOn hand", Description as mDescription, "Days of supply" as "mDays of supply", "To ship" as "mTo ship", "To receive" as "mTo receive", "Lead time, days" as "mLead time, days", "SS periods" as "mSS periods", "Min lot" as "mMin lot", "Safety stock" as "mSafety stock", Clasificacion as mClasificacion, ABC as mABC, [Meses en OC] as [mMeses en OC]