NOTES FROM LAST WEEK

[#1]

Heeello,

Does anyone know how to "script" : take the last [Commnent] from Today -7

I have two columns: Anotation_Date and Comment and i only want to have a chart with the all comments of the last week.

Many thanks!!

B.

[juleshartley]

I would either use the load to add a field called something like 'Comments_last_week' that only populated comments for the previous week, or use set analysis in a chart object to filter the results based on annotation_date

[jpapador]

You want to do a where clause like below when you load in the comments table.

CommentsTable:

LOAD

Comments as LastWeekComments,

Anotation_Date

FROM "YOUR TABLE HERE"

Where Anotation_Date>= Today()-14

and Anotation_Date<= Today()-7;

[#4]

Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?

Thanx!

B

[#5]

Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?

Thanx!

B

[jpapador · Accepted solution]

This is an example if the data is coming from a spreadsheet but always do the where clause at the bottom.

Comments:

LOAD

     Comment,

     Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where Date >= Today()-14

and Date <= Today()-7;

[#7]

It worked!

Many thanks

Maybe you can help me with this... the average should be 100% for the 12 sites but because there are more than one anotation for a single site (because of the different annotation dates) does it make senes to you?

Many thanks in advance,

BQ.