Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
its not working
You need to give more details to help you.
Pedro