0

Line chart not appearing on dashboard.

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.

1 comment

  • 0
    Avatar
    Meggan King

    Hi Randy -

    Charts have a limit of 1000 points. Is it possible you are exceeding the 1000 points limit? Generally there is a detailed message shown when this happens. 

    The support team would be happy to investigate if you'd like to open a support ticket. 

    Thanks!

Please sign in to leave a comment.