Show missing data as 0

[Sumit2504]

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

[MayilVahanan]

HI @Sumit2504 

Try like below

In Dimension tab, check below option

In Presentation tab, check like below

Hope it helps

[Sumit2504]

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

[MayilVahanan]

Hi @Sumit2504 

In that case, u need to generate missed week info in script by assigning zero values. 

Hope it helps.