Hi everyone,
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.
Display info
COLUMN 1 BY YEAR AND MONTH X AXIS
COLUMN 2 Y AXIS THE DATA SAMPLE
NO LEGEND
Data format
COLUMN 1 DATA TYPE DATE FORMAT WEDNESDAY MARCH 1 2021 DONT SUMMARIZE UNCAT
COLUMN 2 FORMAT CURRENCY FIXED DECIMAL SUM
