Spline or Line Chart with Auto Series ...

[Kaster]

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

[Alex K.]

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.

[Kaster]

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.

Report.mrt

Report

(25.19 KiB) Downloaded 350 times

(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>

[Alex K.]

Hello,

Please try to use the DateTime Step property for X-Axis.

Thank you.

[Kaster]

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

[Alex K.]

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.