Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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
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;
Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?
Thanx!
B
Many thanks both, I think the second option suits me...but I dont know how to script "where" can you type exactly?
Thanx!
B
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;
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.