Handling Missing weeks in chart

[Sumit2504]

I've a country data(eg ABC) for which Weeks 12, 13, 14 and 17 are missing from Source data.

When I am trying to create a chart with weeks as dimension, It is not displaying those missing weeks.

Requirement - Is it possible to display data for missing weeks as 0 in chart?

Regards,

Sumit

 

[Sumit2504]

Hi @edwin ,

This solution won't work for me as it will disable the x-axis scrollbar.

Is there any other way where I can see my missing values with x-axis scrollbar.?

[rubenmarin]

Hi @Sumit2504, that wouldn't matter for the calendar if the link between those table is only IdDate... if there are other fields it will create a circular error, usually it is solve concatenating transactional and historical data so you can end with only one fact table instead of two.

[rubenmarin]

Hard to say without having taking a look to data model, it the weeks are greyed out it's because some other selections are excuding them.

Anyway I would try something like [YourExpression]+Sum({1<IdDate={">=$(=Min(IdDate))<=$(=Max(IdDate))"}>} 0)

It maybe needs some fix to adapt to your data model, date format or possible selections.

Other option as @edwin says is to use continuous x axis, for this the dimension should be in number format.

[Sumit2504]

Hi @rubenmarin ,

I tried the expression mentioned by you and @edwin. 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.

[edwin]

attaching a QVW will make this quicker

[Sumit2504]

Hi @edwin , I am not able to see attached file, please reattach again

[edwin]

i was not clear.
i was suggesting if YOU attach a QVW, this process will go quicker
is it obvious we are missing something and looking at the same thing, communication will be clearer

[rubenmarin]

Hi @Sumit2504, if it's showing all dates it's because this: "Sum({1<IdDate={">=$(=Min(IdDate))<=$(=Max(IdDate))"}>} 0)", as I said in previous post "needs some fix to adapt to your data model, date format or possible selections".

Probably you don't have an IdDate field and you ned to use your date field, and the Min/Max may be converted to your date format, also other selections on the app may be take into account.

This could be quicker if you upoload a sample, that's not your client data, it's some data created by you that replicates the issue so we can test.