IS EXPR CORRECT?

[Anonymous]

to find out the  today used space

=sum({<year={$(=year(today())}>}(usedspace/totalspace)*100)

to find out the  yesterday used space

=sum({<year={$(=year(today()-1)}>}(usedspace/totalspace)*100)

i am giving these 2 expressions in bar chart

please tell me these 2 are correct or not ? if not? correct me .

[#2]

Hi,

It won't give today's data.it will give this year data

year(today()) means assume today 14/10/2014 so it will give here year=2014 so it will calculate all the 2014 year data it won't calculate today's data

as it is second expression is also give 2013 year whole data it won't give yesterday's data.

expressions are correct as per your requirement it is not give proper result to you.

[PrashantSangle]

Hi,

Expression is correct but the purpose for which you are using is wrong

If you comparing Year field with today's Year and Yesterday's Year give you

Sum of same year i.e. 2014

Basically if want to comapare with today and Yestarday, You have to compare with complete dateField

i.e. Your expression like

for Today

=sum({<DateField={$(=Date(today())}>}(usedspace/totalspace))*100

or

It can be

sum({<DateField={$(=Date(today())}>} usedspace)/Sum({<year={$(=year(today())})>}Total Space)*100

For Yesterday

=sum({<DateField={$(=Date(today()-1)}>}(usedspace/totalspace))*100

Again check Date Format to get correct Output

Regards

[Anonymous]

here i have no date field what todo ?

[#5]

sorry

you have to mention the today's date like 'datefield = today' and yeasterday's date like  'datefield = today-1'

mention datefield instead of year.

hope this help you.

[Anonymous]

Hi malaya,

instead of datefield in above expression what i need to replace

[#7]

you have give the datefield in the expression

[Anonymous]

i dont have  any date field in my data

[jonathandienst]

Hi

If you have no date field, how do you identify today's records and yesterday's records?

Jonathan

[Anonymous]

that is the main problem here .

but once server reloading every day it will create indidual  qvd for everday