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?
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.
:-(
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
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
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>