So I have a date field and then created a weekday calculated field from this field. The RptDte shows fine, but the weekday is missing if there is no value for that day. Since they are both based on the same source field, why is it showing 1 but not the other.
Weekday = DATENAME('weekday',RptDte )
Tooltip:
Brian,
I wasn't able to reproduce in the overly simplistic example I tried.
Would be grateful if you would modify the spreadsheet
and workbook to more closely match yours.
Of what type is your true datasource?
Unfortunately, this isn't quite as easy as I expected. I am connecting to a SQL server. I pasted the data to an excel sheet and tried to use that as the source and I can't get the line chart to show the 0s even though it is showing /w the SQL version.
Yet I can't seem to get it to show the 0 values even /w the "Show Missing Values" checked, which isnt check on the SQL version.
OK so I found out the issue, it is because I click "Show Missing Values" on the date for dates that have 0 count. Any work around?
Brian,
Apologies for delayed response.I haven't been able to recreate a suitable scenario on my end.
Don't know if this will work for your setup, but one possible
workaround is to make a data scaffold with all the dates of
interest and left join to it.
Then you would be able to say
IF NOT(INSULL([Value]) THEN [Value] ELSE 0 END
This should obviate the need for "Show Missing Values".