Charts like Stock Market

[Sriharsha_Akkin]

Hi,

I am trying to create a chart that looks similar to a stock market chart , that gives you the  value of a stock for the  day  , a week , a month , quarter and year and 5 years.

However when i use parameters and create a dimension group on a date field , its only  brining data on a weekly/monthly/quarterly basis but not the  last 3 months  data or the last 1 month data etc.

I donot want to filter on the explore since i  only  need this for one look and restricting data on the explore level restricts my data. Any  other way i can achieve it?