This is probably the most effective way of getting your results:
LOAD ID, If(Index(Concat(If(IsNull(Value) OR Trim(Value)='',0,1)) ,Repeat('0',10))>0,'Yes','No') AS [10days_flag] FROM [LIB://Downloads/Dev.csv] (txt, codepage is 1252, embedded labels, delimiter is ',', msq) GROUP BY ID;
The Concat() function creates a string consisting of 0's and 1's denoting null value or not. Then searching
this string for 10 zeros is sufficient to determine if it has at least one consecutive period of 10 nulls.
This requires that the Dev.csv is sorted already on ID and Date as your sample data is.
The approach with doing it in a chart instead of the load script would be:
1. Create a table chart after having loaded the data table in the load script
2. Select ID as dimension
3. Use exactly the same expression as the one that was in my previous load script approach for measure:
If( Index( Concat( If( IsNull(Value) OR Trim(Value)='' , 0 , 1 ) ) ,Repeat('0',10))>0,'Yes','No')