I have a data of 6 months I want to calculate the sum of week1+week2, week3+week4...so on...
then I want to divide the sum of these two weeks(14days) by maximum value ....
urgent help is required
This could be accomplished using bins in Tableau. In the following KB use the instructions, but the bin size you would want to create would 14, to accommodate the 2 week time frame.
+ Binning Dates for Custom Date Levels | Tableau Software
Hope this helps!
Retrieving data ...