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))))
I want add 2023 data graph to current date.