Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
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
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.
Where in the scrip do I put that?
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