Charts and Dates

[#1]

Hello,  I am brand new to QV and I have a question regarding dates and charts.  I have a percenage per day for several months.  I would like to create a chart that shows the data by day, week and month.  I think I want to make a drilldown chart.  I have several issues.  First in my chart the data is being shown as a number.  In my list box I can change the number format to date format but I can't in the chart.  Also can I make the drilldown chart for day, month and year with the data recorded by day or would I have to manually add by week and by month?  If I can with the data recorded by day, how would I do this?

[MK_QSL]

1) in the script change date dimension as

Date(YourDate) as Date

This will change your date from Numeric to Date format.

Now you can either create the master calender or add below in your script..

Day(YourDate) as Day,

WeekDay(YourDate) as WeekDay,

Month(YourDate) as Month,

Week(YourDate) as Week,

Year(YourDate) as Year

Hope this help.

[VishalWaghole]

Hi Michael,

DrillDown is possible by this way...

Year-->Quarter-->Month-->Week-->Day.

and

you need to explicitly convert your date format at script level like this

Date(Date#([your date field]),'YYYY-MM-DD')

- Regards,

Vishal Waghole

[jvishnuram]

Hi Micheal,

You need to use the date() function to get the format.,

like date(FIELD,'DD-MM-YYYY') in the creation of drill down fields.

[#5]

Where in the scrip do I put that?

[brijesh1991 · Accepted solution]

Hi,

use a standard calender and link the calender date with your data model, so that you can have weekly, monthly, quarterly, yearly drilldown on front end.

Also in your dimention tab, you can give Date(yourDateField,'DD/MM/YYYY')

which will format your number into date format