06-24-2014 03:13 AM
I have invoice list with dates. As the customer wants to see sales by week, I would like to consume the date in the form of Weeks with numbers. ex: week 1, week 2 week 3 with sales figures.
All I have is dates. I am able to manipulate my dates with all the options available like weekdays, quarter (q1, q2, q3, q4) etc. But I couldn't get weeks with number option.
Pls help with your suggestions. Thanks.
06-27-2014 12:32 AM
If you have a dataset with a date (Invoice date) you can use the week number function (VA 6.3)
Create a new Calculated Item and use the formula week number(Invoice date).
Now you get the week number of the Invoice date. Do not forget to switch the numeric field to a Category before you start using it.
Ones it is a category, you can use it as a label in graphs or tables.
Sure this will work.
Otherwise this is the mathematical function
10-21-2015 08:20 PM
10-22-2015 09:11 AM