Remove hyphen from barchart

[Anonymous]

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)

[PrashantSangle]

in chart property -> dimesion -> tick supress when value is null

Regards,

Prashant

[sunny_talwar]

All you need to do is to check 'Suppress When Value Is Null' for your Open Month dimension on the dimension tab

[arvind_patil]

HI Mahendra,

Check 'Suppress When Value Is Null'  in Dimension Property.

Thanks,

Arvind Patil