https://community.sap.com/t5/technology-q-a/how-to-plot-a-chart-by-creating-timestamp/qaa-p/11955267#M4493970 <P>this <A href="https://blogs.sap.com/2016/06/14/halfhourly-timestamps-in-a-chart/">blog </A>should be helpful in your case.</P> Tue, 25 Jun 2019 07:36:03 GMT Former Member 2019-06-25T07:36:03Z https://community.sap.com/t5/technology-q-a/how-to-plot-a-chart-by-creating-timestamp/qaq-p/11955266 <P>Hi I have a set of data. Which shows start time and end time for each descriptions. I want to plot a bar chart or line with a timestamp for 30 mins interval from 12:00 AM to 12:00 PM and show this start and end data in the chart.</P> <P>How to get the timestamp for each 30 mins and plot the chart? All the data I have is this. STart and End time is in DateTime format and I am getting it from sql server and used IDT to get the data into webi report.</P> <P>Data:</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/1698579-bkj9m.png" /></P> <P>I want it to plot like this in the chart: </P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/1698574-joe3h.png" /></P> <P>Anyone knows how to do it in the WEBI Report?</P> <P> Please help me Thanks!</P> Tue, 25 Jun 2019 06:28:25 GMT https://community.sap.com/t5/technology-q-a/how-to-plot-a-chart-by-creating-timestamp/qaq-p/11955266 Former Member 2019-06-25T06:28:25Z https://community.sap.com/t5/technology-q-a/how-to-plot-a-chart-by-creating-timestamp/qaa-p/11955267#M4493970 <P>this <A href="https://blogs.sap.com/2016/06/14/halfhourly-timestamps-in-a-chart/">blog </A>should be helpful in your case.</P> Tue, 25 Jun 2019 07:36:03 GMT https://community.sap.com/t5/technology-q-a/how-to-plot-a-chart-by-creating-timestamp/qaa-p/11955267#M4493970 Former Member 2019-06-25T07:36:03Z