Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've a country eg ABC, it's data is missing in source DB for weeks 12, 13, 14, 17 and 50.
As I already have a master calendar, so I can see missing weeks as grayed out (Excluded) in list box.
Is there any way I can show data as 0 for those missing weeks in a line chart.
List of dimension and measures used in line chart.
Dimension - Week
Measure - Count(app_Id)
Regards,
Sumit
HI @Sumit2504
Try like below
In Dimension tab, check below option
In Presentation tab, check like below
Hope it helps
Hi @MayilVahanan ,
I used "Show All Values" to force the missing weeks to display. It does display with the line going to 0 properly. However, the chart shows ALL weeks and it'll deselect the range I've selected. So this won't work for my case
Hi @Sumit2504
In that case, u need to generate missed week info in script by assigning zero values.
Hope it helps.