回答:数据里有日期吗?可以加一个日期执行条件比如当天只推送昨天的数据
回答:WITH your_table AS (SELECT 1 AS col1, 'Y' AS col2 FROM dualunion ALLSELECT 2 AS col1, NULL AS col2 FROM dualunion ALLSELECT 3 AS col1, NULL AS col2 FROM dualunion ALLSELECT 4 AS col1, NULL AS col2 FROM dualUNION ALL SELECT 5 AS col1, 'Y' AS col2 FROM dualunion ALLSELECT 6 AS col1, NULL AS col2 FROM dualunion ALLSELECT 7 AS col1, NULL AS col2 FROM dualunion ALLSELECT 8 AS col1, NULL AS col2 FROM dual)SELECT col1, col2, CASE WHEN col2 = 'Y' THEN col1 ELSE LAST_VALUE(CASE WHEN col2 = 'Y' THEN col1 END IGNORE NULLS) OVER (ORDER BY col1 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) END AS col3FROM your_tableORDER BY col1;
回答:月试戴次数单元格*((RAND()*50)/100)https://help.fanruan.com/finereport/doc-view-827.html#146b67c267c54bb8
回答:允许为空去点掉
回答:数据集里保存一下你要显示的值类型对应的单位,之后参考:富文本自定义标签或提示:https://help.fanruan.com/finereport/doc-view-3724.html?source=4
回答:你如果本来就有这个名字,再把复制的也改成这个名字,可能你用的就变成本来的了,这样再改名就都会变化
回答:过滤条件是啥呢?感觉你是因为其中有着一个值为0或者空导致行高为0了可以在后面SUM()一下单元格值,根据SUM的结果设置过滤
回答:模板-模板参数,默认值为1试一下
回答:你绿框内的内容选的什么?你需要把数据表和用户信息表建立数据关联,才能选择参考:https://help.fanruan.com/finebi/doc-view-892.html?source=4#
回答:~~~~~~~~~~~~~~~~~~~~~~~~~··
1085
1085
36
10