Thanks for the quick reply. This solves my problem. However, is there a way to show the intervals on the axis? (i.e., 1-5, 6-10,...)
1 of 1 people found this helpful
Since you already Created the Number Of Days Open So Use This Calc
IF Number of Days<=5 THEN "1-5"
Number of Days>= 6 and Number of Days <=10 THEN "6-10"
ELSE "More than 10"
You can make changes to above Code and use it On Rows or Columns to create Bins.
I realized that this visualization for my data has become somewhat overfilled.
How can I change it to show data for each week instead of a bin of size 5 and group all data older than 6 weeks together?
Also, I want to see week numbers on the horizontal axis.
The final viz should look something like this: