compare create week & close week columns if same return zero and if diff return count close week

[Maddineni_S]

Hey guys,

i have two two columns of data one is created week number another one is closed week. i want to compare two columns and if both columns have same week then zero else it should return count of closed week data.

also i want lastest 8 weeks chart i need.

Submit Week_Num	Resolved Week_Num
42	42
42	42
43	46
43	45
42	42

Count({<Source={'Mc2_nuclues'},Submit_Wk_num = {">$(vmax_weeks)"}>}[Incident ID])

[pedrobergo]

Hi @Maddineni_S 

You have the table, so you create a direct measure to sum that.

Let me call this column as OutOfWeek.

SUM(if((ResolvedWeek_Num - SubmitWeek_Num )>0,1,0))

You can use Set Analysis on this formula:

SUM( {<Source={'Mc2_nuclues'} ,Submit_Wk_num = {">$(vmax_weeks)"}>}  if((ResolvedWeek_Num - SubmitWeek_Num )>0,1,0) )

Then you can use on charts, tables and KPIs.

[],

Pedro

[Maddineni_S]

its not working 

[pedrobergo]

You need to give more details to help you. 

Pedro