Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Here, am getting a hyphen(-) in the bar chart where it should display the name of current month i.e. july.
I can't even apply the filter over there.
load Scrpit:
[PROBLEM_MANAGEMENT_OPENMONTH]:
LOAD MonthName(YEAR_OPEN_DATE,IterNo()-1) as OpenMonth,
PROBLEM_TICKET_OPENDATE,
PROBLEM_TICKET
Resident PROBLEM_MANAGEMENT_ACTIONS
While MonthName(YEAR_OPEN_DATE,IterNo()-1) < MonthName(PROBLEM_TICKET_CLOSEDATE) ;
The expression am using is :
count({< PROBLEM_TICKET_OPENDATE={'>$(=AddMonths(Max(PROBLEM_TICKET_OPENDATE),-60))'}>} DISTINCT PROBLEM_TICKET)
in chart property -> dimesion -> tick supress when value is null
Regards,
Prashant
All you need to do is to check 'Suppress When Value Is Null' for your Open Month dimension on the dimension tab
HI Mahendra,
Check 'Suppress When Value Is Null' in Dimension Property.
Thanks,
Arvind Patil