Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
current graph :
New graph :
I want add 2023 data graph to current date.
Code used Dimensions :
=if(K_Year>Year(Today(0)-1)-1,date(K_MonthYear,'$(vMonthYearFormat)'),if(K_Year>Year(Today(0)-1)-3,K_Year))
Code used Expressions:
f(GetFieldSelections(Work)='IN',Sum({<Work={'IN'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',PCS_SSM,if(Type='SQ',SQ_SSM)))/Sum({<Work={'IN'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',BasePC,if(Type='SQ',SQ_SSM))),Sum({<Work={'OUT'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',PC_SSM,if(Type='SQ',SQ_SSM)))/Sum({<Work={'OUT'},Plant=,Center=,Process=,Name=,[Time - Year]=,[Time - Month]=,[Time - Day]=>} if(Type='PC',BasePC,if(Type='SQ',SQ_SSM))))