-
1. Re: Datepart calculation not showing in tooltip?
swaroop.gantela Sep 27, 2018 8:55 AM (in response to Brian Hansen)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?
-
283090weekday.xlsx 8.6 KB
-
283090tooltip.twbx 18.0 KB
-
-
2. Re: Datepart calculation not showing in tooltip?
Brian Hansen Sep 27, 2018 9:30 AM (in response to swaroop.gantela)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.
-
3. Re: Datepart calculation not showing in tooltip?
Brian Hansen Oct 9, 2018 7:03 AM (in response to Brian Hansen)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?
-
4. Re: Datepart calculation not showing in tooltip?
swaroop.gantela Oct 10, 2018 7:28 PM (in response to Brian Hansen)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".