Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous  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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      sample of results I should haveSample of data

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.