Forum

Notifications
Clear all

Adding a Timeline to my Dashboard

2 Posts
2 Users
0 Reactions
667 Views
(@ccovington750)
Posts: 5
Active Member
Topic starter
 

Hello!

I have created a simple dashboard with 5 charts that tracks calls to our member service center -- and compares one aspect of the calls -- how many of the total calls received are related to my department (eServices)?

Now that I have a good amount of day's data, I'd like to add a timeline filter to focus on pieces of the information month / quarter, etc.  However, I keep getting two errors :

1. "We can't create a Timeline for this report because it doesn't have a field formatted as Date." (I believe it does); and

2. "No data connections in this workbook."

Is it possible to add a timeline without starting over?

Thanks so much!

 

PS.  I dramatically reduced the # of days in data set as the file was very large.  Hopefully this abbreviated file will suffice to illustrate my questions.

 
Posted : 22/10/2022 3:07 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Cynthia,

Thanks for sharing your file. The problem is the dates in column A of the Data Table are text and Excel can't read them as dates. They need to be converted to proper date serial numbers.

See these tutorials on fixing dates formatted as text:

https://www.myonlinetraininghub.com/fixing-excel-dates-formatted-text

https://www.myonlinetraininghub.com/6-ways-to-fix-dates-formatted-as-text-in-excel

Once you've fixed the date format, refresh the PivotTables and try again.

Mynda

 
Posted : 22/10/2022 10:59 pm
Share: