Showing a day by day Date

[phil_asmar]

I have a Date attribute formatted as such : DD/MM/YYYY

The values contained are for the days where data is present, which means the date values are not consecutive as in day 1,2,3 ....

They are as such: Day 1 then 3 then 10

It depends on when there is data available for that date.

I need to show in a chart the dates where there is no values associated too! I want all the dates so that when there are no values, the line chart would flat line (continuous straight line).

Can any one assist me with that?

Thank you in advance

[sunny_talwar]

I think you need to add a Master Calendar in your script to be able to do this. Have a look here: Creating A Master Calendar

[phil_asmar]

I have already done so, but that didn't work. The output is still the same.

[sunny_talwar]

May be in your chart you need to uncheck 'Suppress When Zero' option on the Presentation tab:

[jonathandienst]

See how to fill in missing values here: How to populate a sparsely populated field

[Anonymous]

Hi Phil,

Please Check below Blog post generating missing values:

How to populate a sparsely populated field

See below post also

Autogenerate currency rates

If still unable to solve the issue,please post sample data,will try to help.

Regards

Neetha