Hi,
howto make auto series chart with irregular (many skipped days or not each series has values for same days) DateTimes as Argument (X axis) and decimal values (Y axis) ... X axis must be time scaled and color of line must be dynamic per series
Each example i tried will not work properly or is different from my issue.
There are appropriate examples for my issue?
Thanks
Spline or Line Chart with Auto Series ...
Re: Spline or Line Chart with Auto Series ...
Hello,
Could you explain your issue in more details?
Also, please send us a test data as it present in your data source for analysis.
Thank you.
Could you explain your issue in more details?
Also, please send us a test data as it present in your data source for analysis.
Thank you.
Re: Spline or Line Chart with Auto Series ...
Thanks for your response ...
Report and xml-datasource are attached.
I need scaled X-axis and not same distance between entries on the X axis. For example, entries for 3.3, 5.3 and 22.12 are all with same distance although 22.12 is 9 months after.
I hope I have now correctly explained my issue.
(because rejected upload [attack vector]) I post my xml-data as text below
Thanks
------
<?xml version="1.0"?>
<DATABASE>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>Januar 2017</Monat>
<Data>8</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>1/1/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>Januar 2017</Monat>
<Data>6</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>1/1/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>Januar 2017</Monat>
<Data>10</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>3/1/2017</Date>
</Row>
<Row>
<Series>Bedienung (StdKto)</Series>
<Monat>B...</Monat>
<Data>11</Data>
<Color>Blue</Color>
<Title>Bedienung (StdKto) T</Title>
<Date>20/1/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>Februar 2017</Monat>
<Data>8</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>3/2/2017</Date>
</Row>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>Februar 2017</Monat>
<Data>3</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>6/2/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>Februar 2017</Monat>
<Data>4</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>7/2/2017</Date>
</Row>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>März 2017</Monat>
<Data>7</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>1/3/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>März 2017</Monat>
<Data>5</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>3/3/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>März 2017</Monat>
<Data>5</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>5/3/2017</Date>
</Row>
<Row>
<Series>Bedienung (StdKto)</Series>
<Monat>B...</Monat>
<Data>9</Data>
<Color>Blue</Color>
<Title>Bedienung (StdKto) T</Title>
<Date>22/12/2017</Date>
</Row>
</DATABASE>
Report and xml-datasource are attached.
I need scaled X-axis and not same distance between entries on the X axis. For example, entries for 3.3, 5.3 and 22.12 are all with same distance although 22.12 is 9 months after.
I hope I have now correctly explained my issue.
(because rejected upload [attack vector]) I post my xml-data as text below
Thanks
------
<?xml version="1.0"?>
<DATABASE>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>Januar 2017</Monat>
<Data>8</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>1/1/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>Januar 2017</Monat>
<Data>6</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>1/1/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>Januar 2017</Monat>
<Data>10</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>3/1/2017</Date>
</Row>
<Row>
<Series>Bedienung (StdKto)</Series>
<Monat>B...</Monat>
<Data>11</Data>
<Color>Blue</Color>
<Title>Bedienung (StdKto) T</Title>
<Date>20/1/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>Februar 2017</Monat>
<Data>8</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>3/2/2017</Date>
</Row>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>Februar 2017</Monat>
<Data>3</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>6/2/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>Februar 2017</Monat>
<Data>4</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>7/2/2017</Date>
</Row>
<Row>
<Series>Küche 1 (StdKto)</Series>
<Monat>März 2017</Monat>
<Data>7</Data>
<Color>Green</Color>
<Title>Küche 1 (StdKto) T</Title>
<Date>1/3/2017</Date>
</Row>
<Row>
<Series>Küche 2 (StdKto)</Series>
<Monat>März 2017</Monat>
<Data>5</Data>
<Color>Orange</Color>
<Title>Küche 2 (StdKto) T</Title>
<Date>3/3/2017</Date>
</Row>
<Row>
<Series>Küche 1 (SndKto)</Series>
<Monat>März 2017</Monat>
<Data>5</Data>
<Color>Red</Color>
<Title>Küche 1 (SndKto) T</Title>
<Date>5/3/2017</Date>
</Row>
<Row>
<Series>Bedienung (StdKto)</Series>
<Monat>B...</Monat>
<Data>9</Data>
<Color>Blue</Color>
<Title>Bedienung (StdKto) T</Title>
<Date>22/12/2017</Date>
</Row>
</DATABASE>
Re: Spline or Line Chart with Auto Series ...
Hello,
Please try to use the DateTime Step property for X-Axis.
Thank you.
Please try to use the DateTime Step property for X-Axis.
Thank you.
- Attachments
-
- Capture.PNG (42.65 KiB) Viewed 2799 times
Re: Spline or Line Chart with Auto Series ...
Hm ...
with the proposed route (Month step) is chart view too coarse ... when I choise Day than I need one value for each day ... can this not be avoided? Something like "Show Argument nulls = false"?
Thanks
with the proposed route (Month step) is chart view too coarse ... when I choise Day than I need one value for each day ... can this not be avoided? Something like "Show Argument nulls = false"?
Thanks
Re: Spline or Line Chart with Auto Series ...
Hello,
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Also, please send us a sample how it should look like.
Thank you.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Also, please send us a sample how it should look like.
Thank you.