RE:Daily

[soniasweety]

Hi all,

I want to show the reports for monthly and weekly and daily.  in bar chart  for last 12months,last 12 weeks, and last 12 days.

how can I achieve this?

means  X-axis   I want to show 

jan,feb...

wk01 ,w2,w3

01-jan-2016 like that

can anyone give advice on this?

sample is attached.

[jayaseelan]

Hi Sony,

       I can solve your problem please attach the DATA Test.xlsx file.

Thanks,

[soniasweety]

Hi,

PFA.

[jayaseelan]

Hi Sony,

  To achieve this task you need following extension (which i have attached)for selection the x Axis Dimensions..

Please find tha sample.qvf file..

  hope this will use full for you..

  Thanks,

[soniasweety]

but I don't want to use Extension... I need to show separate charts.

[jayaseelan]

Hi,

    Yes can do that, you need an expression fro last 12 months, Last 12 weeks and last 12 days??

     For last 12 Days you must need date Field, In your data field is not available.

Thanks,

[soniasweety]

DAte field is available in my file .

[jayaseelan · Accepted solution]

Yes Yes Date field is available in Test.xls File,

Use the Following Expressions in bar chart,

For Last 12 Months:

Sum({<Date={">=$(=Date(Addmonths(Max(Date),-12)))<=$(=Date(Max(Date)))"} >}sales)

For Last 12 Weeks:

Sum({<Week = {"<=$(=(Max(Week)))>=$(=(Max(Week) - 11))"}>} sales)

For Last 12 Days:

Sum({< [Date]=,  [Date] = {"<=$(=( date(Max(Date))))>=$(=( date(Max(Date) - 11)))"}>} sales)

I have attached you Sample application !