To set range in overlayI have a data and I want to see scatter plot trend overlay by year. Ive created a year formula, but after I drag it to overlay, it creates a default 5 years range. How can I define my own range when I overlay the trend?
AnalyticsData TableRe: To set range in overlayThank you very much!Re: To set range in overlayJust create a new column, in my example I call it Year Bin. Use the formula:
If(
:Year < 2010, "2005-2009",
:Year < 2015, "2010-2014",
:Year < 2020, "2015-2019",
:Year < 2025, "2020-2025"
)
Which yields the following graph with the year bins as defined in the formula
Re: To set range in overlayPlease could you elaborate further how to formulate that in a column? Thank you
Re: To set range in overlayIt would be my suggestion to create a new column that assigns the ranges to specific bin values, and then use that column as the overlay column.
Re: To set range in overlayIt’s continuous and rather than having it range from 2000-2005, but I want to see every year data ->2000, 2001, 2002, etc
Re: To set range in overlayCan you show us the feature you are looking for in a screen shot?
There is a difference if the column used in overlay is ordinal or continuous
