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
User | Count |
---|---|
130 | |
81 | |
64 | |
57 | |
55 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |