Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
=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,
=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
Hi
PFA. it is sorted now as per your requirement. please mark answers helpful so that whoever visits in future will find it easy.
regards
Pradosh
Can you share a sample app to look into. And did you uncheck supress 0 values in presentation tab of your chart properties.?
Have you created or generated Master calendar in your script?
I have a master calendar
Sorry but I can't
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
Hi Vishwarath,
I have attached some files.
Regards ,
C
Are you looking for this?
Hi
is this what you are looking for ?
regards
Pradosh
I want to Display only the days (16,17,18,19,20,21,22):)