Creating reports and dashboards | Stimulsoft community forum

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

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.

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>

Hello,

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

Thank you.

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

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.