Forum Discussion

DataGeo's avatar
DataGeo
Helper I
8 years ago
Solved

Combination chart showing average rather than actual data values with combined dates

I've got 2 different excel sheets of data within the same time period, but one table is simply by year while the other has specific days within these years. Different date formats basically.   I am...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Share the link from where i can download your workbook.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution from here.

     

    Hope this helps.

     

DataGeo's avatar
DataGeo
Helper I
8 years ago

Hi Ashish,

 

I tried changing the column to a date column exactly like how it is in your solution but could not get rid of this error. I don't understand why in your solution it works but in mine it is always giving an error.

 

You will see it in the data table titled "Donations". 

 

Thanks again for your help with this.

 

Here is the file: https://drive.google.com/open?id=1y1MQ7qbbpy2ja0q2lXE9rg0wGxlpKE5O

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

That is happening because there are blanks in the Year column of the donations table.  Fill in those blank cells.  Else, you may also try this calculated column formula

 

=if(ISBLANK(Donations[Year]),DATE(2013,1,1),1*("1/1/"&Donations[Year]))

 

Hope this helps.

  • DataGeo's avatar
    DataGeo
    Helper I
    8 years ago

    Yes! That's it. Wow the error is not very descriptive in telling you about the blank columns. Thanks so much for all your help Ashish you're the best!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.  Glad to help.