Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have another scenario :
t1:
Load * Inline
[
Year,Region,Impact
2018,India,Low
2018,SriLanka,Low
2018,Australia,Significant
2018,Japan,Low
2019,India,Low
2019,SriLanka,Low
2019,SriLanka,Significant
2019,India,Medium
2019,Australia,Low
2019,India,Significant
2019,UK,Significant
2019,UK,Low
];
Here we need to consider the same year and also Impact equal to Significant
For example in 2018 it will be,
India = 0
Sri Lanka = 0
Australia - 1
Japan - 0
Median will be zero
In 2019,
India - 1 (Impact is equal to Significant in one case)
SriLanka - 1 (Impact is equal to Significant in one case)
Australia - 0 (Impact is equal to Significant in zero case)
UK - 1 (Impact is equal to Significant in one case)
Median for 0,1,1,1 which is 1
Hello all,
Anyone please assist on this.
Thanks & Regards,
Arvind
And your question is?
Hi Jonty,
Thanks for the response.
I have below scenario :
t1:
Load * Inline
[
Year,Region,Impact
2018,India,Low
2018,SriLanka,Low
2018,Australia,Significant
2018,Japan,Low
2019,India,Low
2019,SriLanka,Low
2019,SriLanka,Significant
2019,India,Medium
2019,Australia,Low
2019,India,Significant
2019,UK,Significant
2019,UK,Low
];
Here we need to consider the same year and also Impact equal to Significant
For example in 2018 it will be,
India = 0
Sri Lanka = 0
Australia - 1
Japan - 0
Median will be zero
In 2019,
India - 1 (Impact is equal to Significant in one case)
SriLanka - 1 (Impact is equal to Significant in one case)
Australia - 0 (Impact is equal to Significant in zero case)
UK - 1 (Impact is equal to Significant in one case)
Median for 0,1,1,1 which is 1