Tableau自定义SQL不按预期工作

Question

我是Tableau的新手，希望能够从DB2导入SQL，以便最初导入并编译可视化。我有一个db2连接，然后去自定义sql，但没有加载之后。代码不是很复杂，但我确实有一些case语句。我试着这样做，但这似乎并没有给我什么sql做。主要问题是我有一个字段，我需要从两个不同的日期拉，然后只显示这两个日期不一样的结果。这是可能的在Tableau与以下查询?

SELECT 
RMD.ISSUE_ID,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.ISSUE_TITLE END) AS CURR_ISSUE_TITLE,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.MEMBER_IMPACT END) AS CURR_MEMBER_IMPACT,
MAX(CASE WHEN AS_OF_DATE = '2021-08-08' THEN CURRENT.MEMBER_IMPACT END) AS PREV_MEMBER_IMPACT,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.ISM_STATUS END) AS CURR_ISM_STATUS,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.ISSUE_OWNER_ORG END) AS CURR_ISSUE_OWNER_ORG,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.ISSUE_OWNER END) AS CURR_ISSUE_OWNER,
MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.ISSUE_APPROVER END) AS CURR_ISSUE_APPROVER
FROM LOD.ISM_ISSUE_SUMMARY_HIST_WKY CURRENT INNER JOIN
LOD.RMD_ISS_REMED_SUMMARY RMD
ON CURRENT.ISSUE_ID = RMD.ISSUE_ID
WHERE AS_OF_DATE IN ('2021-08-08', '2021-08-15') 
GROUP BY RMD.ISSUE_ID
HAVING MAX(CASE WHEN AS_OF_DATE = '2021-08-08' THEN CURRENT.MEMBER_IMPACT END) <> MAX(CASE WHEN AS_OF_DATE = '2021-08-15' THEN CURRENT.MEMBER_IMPACT END) ;

我试着写这个，但似乎没有做任何事情，因为它只是一个查询，或者我不知道如何完成它来完成完整的查询。

IF [As Of Date] = #2021-08-15# THEN [Issue Title] ELSEIF  
[As Of Date] = #2021-08-15# THEN [Member Impact] ELSEIF
[As Of Date] = #2021-08-08# THEN [Member Impact] ELSEIF
[As Of Date] = #2021-08-015# THEN [Ism Status] ELSEIF
[As Of Date] = #2021-08-015# THEN [Issue Owner Org] ELSEIF
[As Of Date] = #2021-08-015# THEN [Issue Owner] ELSEIF 

[As Of Date] = #2021-08-015# THEN [Issue Approver] END

是否有可能在Tableau中引入我的查询?

Answer 1

如果去掉分号(";")，查询还能正常工作吗?