Display the missing date in a Bar Chart

[0li5a3a]

Hi all,

I have a new challenge today to display all the dates if I don't have data in a Bar Chart for the previous week.

I have a filter which contains all the YearWeeks and two charts one is for the current selections and one for the  previous  week.

For the current selection I can display the missing dates like in the chart below.

My problem is with the previous  week where the chart looks like below where you can see that the dates 23 and 24 are missing.

My dimension for both charts is the calendar Day and my expressions are:

Current Selections:

=count({$<Status = {'Approved', 'Scheduled'},WeekNumber = {'$(=Max(WeekNumber))'}>}TicketD)  and

=sum({<WeekNumber = {'$(=Max(WeekNumber))'}>}1) ( I use this to display the nulls ) and like you can see all works,

Previous Week:

=count({1<Status = {'Approved', 'Scheduled'},WeekNumber = {'$(=Max(WeekNumber)-1)'}>}TicketID)

I tried to use =sum({<WeekNumber = {'$(=Max(WeekNumber))'}>}1)  and Sum(1) but the chart looks wrong

Could someone please help me?

Regards,

C

[vishsaggi]

Can you share a sample app to look into. And did you uncheck supress 0 values in presentation tab of your chart properties.?

[Anil_Babu_Samineni]

Have you created or generated Master calendar in your script?

[0li5a3a]

I have a master calendar

[0li5a3a]

Sorry but I can't

[vishsaggi]

You can hide the confidential info following this?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling

[0li5a3a]

Hi Vishwarath,

I have attached some files.

Regards ,

C

[vishsaggi]

Are you looking for this?

[pradosh_thakur]

Hi

is this what you are looking for ?

regards

Pradosh

[0li5a3a]

I want to Display only the days (16,17,18,19,20,21,22):)