Could you please attach sample data as twbx.
You will need to create 3 calculations to determine the value of each bucket (Current Week, Last 4 Weeks, & YTD) respectively. Once you do this you can plug them into the view and create the view as you have in Excel.
Current Week: IF (DATEDIFF('week',[Date],TODAY()))<=1 THEN [Volume] END
Last 4 Weeks: IF (DATEDIFF('week',[Date],TODAY()))<=4 THEN [Volume] END
YTD: IF (DATEDIFF('year',[Date],TODAY()))<=0 then [Volume] END
Workbook attached with these calcs.
If you find it useful, then please mark this answer Correct, this way others can benefit from it. Thank you!
Side by side chart.twbx 23.5 KB
This looks promising. Will try this tonight and let you know how it works.
Did it work?
Thanks so much for offering this solution. The problem I am running into is that your solution has a single Dimension (behavior) that you are tossing into Columns. My data is a little less simple and each 'behavior' is it's own Measure. I am calculating the percentages as 'carts / users', 'order details / users', and 'transactions / users'.
I've attached a sample csv of what my dataset looks like.
I really appreciate the help you have offered.
There isn't a way to Create a Dimension for what you are looking to achieve. Is your Data allowing you to Pivot in order to achieve this?
Normally you should do the Pivot upfront - in Connect Data window of the dataset allows it or via Custom SQL.
Let me know. Thank you.
Thanks Ankit. Sounds like my best course is to set up a new data source that is better suited to this view. I'll work on that.
In the mean time I'm going to mark your first answer as correct since I think that will work for most people.