problem sorting time X -axis

Posted by dario borsotti

Posted on Tue, 08/17/2010 - 11:40 in MashZone

Hi all,

here my problem. I create a 2 columns datafeed containing 24 values formated in this way:

dd-MM-yyyy HH || VALUE

hour values are from 00 to 23

when I create the graphics I set "sorting by time" and "ascending" (I also tried "nothing") and the result is a graph showing values from 2 - 23 and then the 0 and 1 at the right end of the graph.

where is the problem?

24.8k

by Markus von den Driesch

Posted on Wed, 08/18/2010 - 09:02

Could you provide a screenshot of the data mode of the chart and the actually data fed into that chart? I am not quite sure if understand correctly, what you want to achieve.

Best regards,

Markus

by dario borsotti Author

Posted on Wed, 08/18/2010 - 16:36

I did more analyses and I found the problem, but not the solution.

Here the data on PPM:

These data are correct, and so the favorite.

The problem is that in some strange way, during import of the data into MASHZONE, from the datafeed connector, all the values are moved of 2 hours.

I mean that the value "12" in the table related correctly in PPM to 8:00 am is associated to the 10:00 am in Mashzone, and so on, the value "15" related to 17/08/10 23:00 is moved to 18/08/10 01:00. All the values are correct but they are "moved".

So the result is a graph that start at 17/08/10 02:00 and finish at 18/08/10 01:00

I was thinking to some problem related to legal hour, but I didn't find any configuration about this. ps: The hours on the server is correct.

:-(

by Markus von den Driesch

Posted on Thu, 08/19/2010 - 14:19

I understand that you extract data from a PPM system. In PPM the table shows the correct values. If you debug this favorite directly in the PPM datasource in Mashzone - do you see the correct values or the shifted values?

Could the check the output of the PPM query API by copying the favorite Query API-URL into your browser and check the results there.

At first glance, it seems to be a timezone issue.

Thanks and regards,

Markus

by dario borsotti Author

Posted on Fri, 08/20/2010 - 12:26

If you debug this favorite directly in the PPM datasource in Mashzone - do you see the correct values or the shifted values?

In the preview area of Mashzone of the PPM datasource the values are wrong.

Could the check the output of the PPM query API by copying the favorite Query API-URL into your browser and check the results there.

copying in the browser the URL, the values I see are correct!

:-( I agree with your opinion about time zone, but the servers setup are correct, the hours are similar, and I didn't find in Mashzone or in PPM any configuration area about timezone

by Markus von den Driesch

Posted on Fri, 08/20/2010 - 18:02

We will keep on trying to reproduce this and come back to you if we need additional information.

by Bernd Ziegler

Posted on Fri, 08/27/2010 - 07:56

Hello,

we tried to reproduced this effect in our team but it was not possible.

Is it possible to give us the PPM query API ( what you see in your browser ) as xml file for that favorite? Perhaps it will help to reproduce this.

Thanks in advanced,

by dario borsotti Author

Posted on Fri, 08/27/2010 - 16:28

Probably I found the problem. I didn't note that the xml have wrong "value" and correct "expression".

But why?

I mean, in PPM the favorite is correct.... should be a problem of Mashzone importing data?

 <?xml version="1.0" encoding="UTF-8" ?> 
  <!DOCTYPE queryresult (View Source for full doctype...)> 
- <queryresult>
- <header>
  <query type="SHARED" title="Tempo Medio Activation USIM Business">_Technical_Dashboard\attivazione_usim\MZ\TAB\REL_TEMPI_QTY_attivazione_usim_D</query> 
  <session client="h3g_sqi" user="SYSTEM" language="en" /> 
  <timestamp>2010-08-27T16:14:28</timestamp> 
  <column name="TIME" datatype="TIME" usage="ITERATION">Time [By hour]</column> 
  <column name="KI_AS_NUM_EVENTI" datatype="LONG" usage="KEYINDICATOR">AS Numero Eventi</column> 
  <column name="Perc_comp_entro_24H" datatype="PERCENTAGE" usage="KEYINDICATOR">% Flusso completati entro 24 H su totale eventi [%]</column> 
  <column name="DIff_RESP_PUBL" datatype="TIMESPAN" usage="KEYINDICATOR">Media dei Delta RESPONSE - PUBBL. SU EAI [Minutes]</column> 
  </header>
- <data>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T02" value2="yyyy-MM-dd'T'HH">26/08/10 0:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="2">2</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="0.49">0.49</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T03" value2="yyyy-MM-dd'T'HH">26/08/10 1:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="1">1</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.00">1.00</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T04" value2="yyyy-MM-dd'T'HH">26/08/10 2:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T05" value2="yyyy-MM-dd'T'HH">26/08/10 3:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="1">1</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="0.75">0.75</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T06" value2="yyyy-MM-dd'T'HH">26/08/10 4:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T07" value2="yyyy-MM-dd'T'HH">26/08/10 5:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T08" value2="yyyy-MM-dd'T'HH">26/08/10 6:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T09" value2="yyyy-MM-dd'T'HH">26/08/10 7:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T10" value2="yyyy-MM-dd'T'HH">26/08/10 8:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="149">149</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.12">1.12</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T11" value2="yyyy-MM-dd'T'HH">26/08/10 9:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="224">224</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="6.75">6.75</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T12" value2="yyyy-MM-dd'T'HH">26/08/10 10:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="709">709</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="10.41">10.41</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T13" value2="yyyy-MM-dd'T'HH">26/08/10 11:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="719">719</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="3.75">3.75</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T14" value2="yyyy-MM-dd'T'HH">26/08/10 12:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="640">640</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="4.90">4.90</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T15" value2="yyyy-MM-dd'T'HH">26/08/10 13:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="240">240</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.21">1.21</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T16" value2="yyyy-MM-dd'T'HH">26/08/10 14:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="136">136</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="0.84">0.84</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T17" value2="yyyy-MM-dd'T'HH">26/08/10 15:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="245">245</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="0.94">0.94</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T18" value2="yyyy-MM-dd'T'HH">26/08/10 16:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="506">506</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.83">1.83</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T19" value2="yyyy-MM-dd'T'HH">26/08/10 17:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="734">734</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.42">1.42</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T20" value2="yyyy-MM-dd'T'HH">26/08/10 18:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="781">781</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.15">1.15</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T21" value2="yyyy-MM-dd'T'HH">26/08/10 19:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="739">739</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="1.13">1.13</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T22" value2="yyyy-MM-dd'T'HH">26/08/10 20:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="205">205</kc> 
  <kc name="Perc_comp_entro_24H" scale="PERCENT" value="100.000">100.000</kc> 
  <kc name="DIff_RESP_PUBL" scale="MINUTE" value="0.96">0.96</kc> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-26T23" value2="yyyy-MM-dd'T'HH">26/08/10 21:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-27T00" value2="yyyy-MM-dd'T'HH">26/08/10 22:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
- <row>
  <dc name="TIME" type="DATE" value="2010-08-27T01" value2="yyyy-MM-dd'T'HH">26/08/10 23:00</dc> 
  <kc name="KI_AS_NUM_EVENTI" value="0">0</kc> 
  <kc name="Perc_comp_entro_24H" /> 
  <kc name="DIff_RESP_PUBL" /> 
  </row>
  </data>
  </queryresult>

by Bernd Ziegler

Posted on Mon, 08/30/2010 - 08:47

That's it, you found it right.

But there isn't an error on the mashzone side, it is an error on the PPM side. The PPM query Api delivers wrong data, we are trying to resolve it for next SR of PPM.

by Markus von den Driesch

Posted on Mon, 08/30/2010 - 17:26

Which PPM version are you using?

by dario borsotti Author

Posted on Mon, 08/30/2010 - 18:29

Aris PPM 4.1.2

by Markus von den Driesch

Posted on Tue, 08/31/2010 - 12:45

This was an issue the old version PPM 4.1.2, which uses a different timezone in the output of the Query API. This is fixed with PPM build 5852 or higher.

Best regards.