KPI Seasonal measure by selected period

[devarasu07]

Hi All,

PFA, I've KPI dashboard requirement like below screen image. based on user selected Week & year need to find the current season  and last 3 season Qty. Sold measure. is there anyway to fulfill such a requirement. kindly advise.

if we changed to different period then it's Seasonal launch value should change automatically.

Attached with sample mock report, and note below,

1) our company we use customized seasonal launch master file.(source attached in the doc.)

2) report layout like above format (pivot table with column - into row transformed type)

Thanks,

Deva

[devarasu07]

Hi stalwar1‌

I've got no clue, if you have any thoughts on this please share your valuable input. may thanks

Regards,

Deva

[sunny_talwar]

Can you reload your app with this?

LOAD*,

if(Month=1  or Month=2 or Month=3 , 'Spring'&'-'&Year,

  if(Month=4  or Month=5, 'Summer'&'-'&Year,

  if(Month=6, 'Summer JIT'&'-'&Year,

  if(Month=7 or Month=8 or Month=9, 'Fall'&'-'&Year,

  if(Month=10 or Month=11, 'Winter'&'-'&Year,

  if(Month=12 ,'Winter JIT'&'-'&Year,

  )))))) as SeasonLaunch,

  Year*100+Month as FiscalYearMonth;

I guess I can look into it once you share the updated app. I am not sure why you are reluctant to run this?

Note: Changed the name to FiscalYearMonth because you already had MonthYear in your table befor.

[aarkay29]

PFA

[devarasu07]

Hi stalwar1‌,

mbaeyens‌

celambarasan‌

mto‌

gwassenaar‌

maxgro‌

dpi‌

Need to show output like below (currently last four seasonal measure hard coded value placed for year 2015 & Month is Dec) selection.

but i'm looking based user selected year & week these last four seasons should change respectively. any thoughts or suggestion on this. Thanks

Thanks, Deva

[sunny_talwar]

Look at the attached

Created a new field

AutoNumber(if(Month=1  or Month=2 or Month=3 , 'Spring'&'-'&Year,

  if(Month=4  or Month=5, 'Summer'&'-'&Year,

  if(Month=6, 'Summer JIT'&'-'&Year,

  if(Month=7 or Month=8 or Month=9, 'Fall'&'-'&Year,

  if(Month=10 or Month=11, 'Winter'&'-'&Year,

  if(Month=12 ,'Winter JIT'&'-'&Year,

  ))))))) as SeasonLaunchOrder,

and used this

Sum({<Month=,Year=,Week=,SeasonLaunchOrder={$(=Max(SeasonLaunchOrder))}>}SoldQty)

Why did you skip Fall-2015?