Hi @Sumit2504, to show that weeks they have to be loaded as a value, usually is a best practice to have an independent table to use as master calendar, this will covre all dates since the min date found in data to the end.
Data tables will only have date field, the other related fields from that dates (week, month...) will be on master calendar table.
You can crete a master calendar as:
Calendar:
LOAD
IdDate,
Date(IdDate) as Date,
Month(IdDate) as Month,
Num(Month(IdDate)) as MonthNum,
Year(IdDate) as Year,
Date(IdDate, 'YYYY/MM') as Year_Month
;
LOAD
MinFecha + IterNo()-1 as IdDate
While MinDate + IterNo()-1 <= MaxDate
;
LOAD
Floor(Min(FieldValue('IdDate', RecNo()))) as MinDate,
Floor(Max(FieldValue('IdDate', RecNo()))) as MaxDate
AutoGenerate FieldValueCount('IdDate');
// IdDate is the field name of the date in your data table
Still maybe you need to add +Sum({1}0) to your expression to show all weeks
