Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This date field works fine everywhere else but in this new chart, it shows as 1900. I added date#() in the script but it didn't fix it.
Script:
date("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY') as ADJ_GOVERNANCE_PHASE_START_DATE,
Dashboard displays all as 1900
Chart Dimensions: (ADJ_GOVERNANCE_PHASE_START_DATE)
Chart expression: if(isnull(ADJ_GOVERNANCE_PHASE_END_DATE),ADJ_GOVERNANCE_PHASE_START_DATE-date(today()),ADJ_GOVERNANCE_PHASE_TAT)
@cbaqir In chart properties->Axis-> Static Min and Static Max expression causing this issue. Uncheck that
What's the output in ADJ_GOVERNANCE_PHASE_START_DATE? You need to ensure it hold a date value.
You are saying that you are using date#(), but your definition is written without #.
Try this to verify that your field is a date.
Date (date#("ADJ_GOVERNANCE_PHASE_START_DATE", 'MM/DD/YYYY')) as ADJ_GOVERNANCE_PHASE_START_DATE,
Unfortunately, that did not make a difference.
I use that field in lots of other places and it works fine. I'm not sure why this view does not show it correctly.
QVW Attached
@cbaqir In chart properties->Axis-> Static Min and Static Max expression causing this issue. Uncheck that
That definitely fixed part of the issue! Thanks. The dates still aren't formatted correctly though. Any idea?
@cbaqir that probably due to Date# applied. As you already formatted that field as Date no need to use Date#
That doesn't seem to fix it.
@Kushal_Chawda Close but not quite. I've been playing with this: =if(not match(ADJ_GOVERNANCE_PHASE,'5.2 - Ticket Completion'), date(ADJ_GOVERNANCE_PHASE_START_DATE,'M/D/YYYY'))