I have a line chart that appears fine in the editor/preview, but will not show up on a dashboard. My data source is an Excel file. Column A is order number, column C is invoice date, column E is days to complete order. Here is the code I use:
STANDARDIZE(
@XLSX,E:E;,
AVERAGE(
SELECT(
@XLSX,E:E;,
BETWEEN(
date(@XLSX,C:C;, "MM/dd/yy"),
DATE_ADD(TODAY(), "5", -60),
TODAY()
)
)
),
STDEVP(
SELECT(
@XLSX,E:E;,
BETWEEN(
date(@XLSX,C:C;, "MM/dd/yy"),
DATE_ADD(TODAY(), "5", -60),
TODAY()
)
)
)
)
Here is the graph as it appears in the editor/preview:
And here is how it appears on the dashboard:
Any help in getting this to appear correctly would be appreciated. Thank you very much.