4 weeks data

[#1]

Hi all,

I have attached the sample data.

I need bar graph on week basis, last 4 weeks data.

and also for last week. please help me.

Thanks,

Pramod

[#2]

Hi Gysbert Wassenaar,

If i give like this it will produce 1;

count({$<week_number={$(vMaxWeek)}>}invitation_id)/count(TOTAL{$<week_number={$(vMaxWeek)}>}invitation_id).

here i am taking vMaxWeek has variable.

AND

I need a line graph like below and here we have to give some start date and end date for that it should produce line graph and the data point should take randomly or three months once. see the image below.

Please help this.

Thanks,

Pramod

[Gysbert_Wassenaar]

If i give like this it will produce 1;

Perhaps you need to change the number format setting so that it will show percentages instead of whole numbers.

[#4]

Hi Gysbert Wassenaar,

Great thanks, today you helped me lot. i found answers for many issues.

If you don't mind will you explain why we have used below lines, it's functionality.

date#(left(date_created,10),'YYYY-MM-DD') as date_created,

time#(mid(date_created,12,8),'hh:mm:ss') as time_created,

Thanks,

Pramod

[Gysbert_Wassenaar]

The date_created values in your csv file couldn't be interpreted as timestamp values directly because the contained extra characters like T and Z. That's why I used left and mid to extract the parts with the date and the time from the text string.

[#6]

ok what about that line graph?  Gysbert Wassennar

Thanks,

Pramod

[Gysbert_Wassenaar]

Start a new discussion please.