Null vs 0 in Line Chart

[cbaqir]

The issue I am having is that if the Avg # of days between two selected PROCESS steps is 0, it should show as 0 and not null.

Example: DEFECT_ID = 6036

PROCESS_STEP = Ticket Created and Routed

Expression: SUM(
Aggr(
Max(PROCESS_STEP_START_DATE)- Min(PROCESS_STEP_START_DATE)
,DEFECT_ID)
)
  /Count({$<DEFECT_ID = {"=Count(PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}>}DISTINCT DEFECT_ID)

You can see from the tables that the data is showing as 0 but is not showing on the line chart. I tried an if(isnull()) but it didn't fix it. Any suggestions?

[YoussefBelloum]

Hi,

try with this:

=if(len(trim(your_field))=0,...

[cbaqir]

No change. I think the issue might be 0/1... but it shows as 0 in the table. I noticed that the month/year doesn't populate in the table though. Maybe that's the issue?

if(len(trim(GOV_PROCESS_QUEUE_TAT))=0,SUM(
Aggr(
Max(PROCESS_STEP_START_DATE)- Min(PROCESS_STEP_START_DATE)
,DEFECT_ID)
)

/Count({$<DEFECT_ID = {"=Count(PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"}>}DISTINCT DEFECT_ID))

[vishsaggi · Accepted solution]

Just uncheck this in your chart properties.

[cbaqir]

Duh. Thanks