tough task?

[Anonymous]

Hi folks,

i have  3 databases calles like  a1,a2, a3 storage area nothing( disks)   and having 6 dash boards

here  i have fileds called  used space and non used space

and i have already detils of  each dashboard used disk space and unused disk space for every storage areas

example:

stacked barchart( feel like that)

a1:                                                                             as well as for a2   and a3 also

dashboard1  --used space-notused space

d2                  --used space-notused space 

d3                    --used space-notused space

d4                  --used space-notused space

d5                 --used space-notused space

d6               --used space-notused space

my req is i want to write expression for  what is used space for dashboard1 in A1(storage area) for yesterday vs today

last week vs previous (taken sapce for d1,d2,d3...)

lastmonth vs previous month (d1,d2,d3,d4.....)

[suresh_rawat]

Hi,

For this you can create your own date for eg : - using date(today()) in your script and capture daily data.

In Filters, Select - Year & Month.

For Today usage use - sum( {$<year = {$(=Max(year))}>} Used Space/ Unused space)

For Yesterday - sum( {$<year = {$(=Max(year)-1)}>} Used Space/ Unused space)

I hope this will help you.

Regards

Suresh Rawat

[Anonymous]

here i need to create master calendar?

[suresh_rawat]

Hi,

If you want you can create Master Calendar.

Otherwise, when you get data from the data sources through a query just add this column in the query as Today() as date.

Then, after save this data in QVD file. Use this date to get year, month, day for eg: - Year(date) as year.

[suresh_rawat]

Hi,

With the use of the above expression you can get your all results in your dashboards.

1) Current Day Vs Previous Day - Just select Year, Month & Day from your fields.

2) Current Month Vs Previous Month - Just Select Year & Month Field.

[#6]

Hi,

here it will come whole year data right bt i need only today's data and yesterday's data.

Max(year) means it will give whole year data

max(year)-1 means it will give prev year data right.

[suresh_rawat]

Hi,

If you don't want to use Year, Month & Day filter then you can add 1 condition in the above Set Analysis Expression Year(today()), Month(today()), day(today()) for Current Day Vs Previous Day.

For Current Month & Previous Month - Add Year(today()), Month(today()) in the Set analysis Expression.

[Anonymous]

while creating bar chart what are dimension i have to use  while using this expressions

and more info  i have fileds month ,year and processing date

but there is no relation ship between month, year to processing date ?

what to do ?

[suresh_rawat]

[suresh_rawat]

In this Example I have taken Days as Dimension and calculate data for Current Month , Previous Month and Last Year Current Month Wise data.