Extracting date from timestamp and Plotting of blockwise data on a chart

[#1]

Hi,

I extract date from a timestamp field as follows:

LOAD DATETIME,Floor(DATETIME)as My_Date;

   SQL SELECT  DATETIME

   FROM `xyz_data`;

My data is in form of 48 blocks which corresponds to 1 day.

How should I plot a graph which should show data of all 48 blocks when I select a date.

Please Help

Thanks

Asmita

[ariel_klien]

Hi,

Try to put in the expression:  =All

BR

Ariel

[#3]

Hi Asmita,

  Can you provide more clarity/or share your qvw file

-Jay