I know there are limitations on custom charts, like must have DateTime - but even when I feed specific data to the report, I still seem to have generation problems.
I've already pulled my values through SQL and pushed through a rounded DatePart to DateTime per day (since all I care about is per day), but I can't get the values to chart.
17 nodes, one measurement per day, two values in two columns. Output in SQL is similar to below. 435 rows.
| 2017-01-16 00:00:00.000 | P0KG | 21 | 74.39 |
But no matter what I do in the Custom Chart resource, I can't get values to display. I've tried with just a single node, I've tried every Time Period sample interval (which is really redundant) - and still I stare at "Data is not available".
Can anyone point me in the right direction?
Thanks in advance,
Matt
