topic Re: To set range in overlay in Discussions

To set range in overlay

Nebula — Sat, 10 Jun 2023 23:29:14 GMT

I 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?

Re: To set range in overlay

mlo1 — Mon, 26 Apr 2021 22:29:54 GMT

Can 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

Re: To set range in overlay

Nebula — Tue, 27 Apr 2021 00:49:29 GMT

It’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 overlay

txnelson — Tue, 27 Apr 2021 01:05:11 GMT

It 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 overlay

Nebula — Tue, 27 Apr 2021 01:14:49 GMT

Please could you elaborate further how to formulate that in a column? Thank you

Re: To set range in overlay

txnelson — Tue, 27 Apr 2021 01:42:28 GMT

Just 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 overlay

Nebula — Tue, 27 Apr 2021 02:30:51 GMT

Thank you very much!