cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
devongoble Frequent Visitor
Frequent Visitor

Linking multiple sheets via date

I have pulled in multiple data sources from SharePoint 365.

 

I am trying to build some stacked visuals as well as pie charts.

 

Each sheet is unique in what it captures, except for Id field and date.

 

I have tried creating a date table and linking them all to it via relationships.

 

When I do this, the chart is blank. (date as axis and 'count of ID as value)

 

I can use one of the sheets date field and count and it looks great, add another sheets ID count into value and it WILL show up, but only as the total sum consistently each month.

 

I have killed myself trying things and searching reddit and on here for help.

 

I hope some one can help out.

 

sample pic.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
devongoble Frequent Visitor
Frequent Visitor

Re: Linking multiple sheets via date

Figured it out!!

While I had edited the fields to all match date types. I then went into each table in query edit....the fields were NOT date type there.

 

Transformed them there, linked to date table...BOOM! all is well.

4 REPLIES 4
Super User
Super User

Re: Linking multiple sheets via date

@devongoble  can you share sample data and expected result, will get you the solution. Reading at requirement and it look like something easy and not sure why it is not working for you.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






devongoble Frequent Visitor
Frequent Visitor

Re: Linking multiple sheets via date

desired results.PNGsample of results I should havesample pic.PNGSample of data

devongoble Frequent Visitor
Frequent Visitor

Re: Linking multiple sheets via date

I am trying to get all these tables I pulled in to link to a single date field. I then am counting them by iD. This way I can see how many 'items' in each table were created over a time frame.

devongoble Frequent Visitor
Frequent Visitor

Re: Linking multiple sheets via date

Figured it out!!

While I had edited the fields to all match date types. I then went into each table in query edit....the fields were NOT date type there.

 

Transformed them there, linked to date table...BOOM! all is well.