Hopefully a simple request for help. I was able to get it to work once and now I cannot so I feel like I am missing something.
What I want to do:
I take a sample of data every month. I want to take that sample and place it in BI and then use the forecast analytics to project seasonal and linear trending.
I was able to do this previous but now I cannot. Whenever I attempt to just display the data it either adds up the data in the column or it doesn't understand the data is linear and does not connect the dots in a line chart.
Here is the format of the data that worked the first time.
|Friday, January 1, 2021||1,111,899|
|Monday, February 1, 2021||1,004,910|
|Monday, March 1, 2021||1,006,049|
|Thursday, April 1, 2021||1,175,960|
|Saturday, May 1, 2021||1,038,015|
|Tuesday, June 1, 2021||1,047,690|
|Thursday, July 1, 2021||925,104|
|Sunday, August 1, 2021||1,281,344|
|Wednesday, September 1, 2021||1,125,269|
|Friday, October 1, 2021||1,036,265|
|Monday, November 1, 2021||1,010,210|
|Wednesday, December 1, 2021||1,054,195|
|Saturday, January 1, 2022||1,064,466|
|Tuesday, February 1, 2022||1,083,297|
|Tuesday, March 1, 2022||1,000,819|
|Friday, April 1, 2022||1,149,080|
|Sunday, May 1, 2022||1,145,499|
|Wednesday, June 1, 2022||1,102,082|
|Friday, July 1, 2022||1,062,686|
|Monday, August 1, 2022||1,173,327|
Here is how I got it to work the first time that I cannot duplicate now.
COLUMN 1 BY YEAR AND MONTH X AXIS
COLUMN 2 Y AXIS THE DATA SAMPLE
COLUMN 1 DATA TYPE DATE FORMAT WEDNESDAY MARCH 1 2021 DONT SUMMARIZE UNCAT
COLUMN 2 FORMAT CURRENCY FIXED DECIMAL SUM