Home › Topic › Dashboard error

Dashboard error

Posted on by Robert de Vries Posted in

Home › Forums › Basic setup › Dashboard error

Tagged: ,

This topic contains 1 reply, has 2 voices, and was last updated by  mhawksey 5 years, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • November 9, 2015 at 4:52 pm #639

    Robert de Vries
    Participant

    Hi,

    I’ve loaded in some data and have an archive with about 1000 tweets. However, most of the Dashboard sheet is not displaying any data. The ‘top tweeters’ chart is populated, but the ‘tweet volume over time’, ‘twitter activity’ and ‘tweets with the most RTs’ are not.

    The latter table has an error which reads “This function is not allowed to reference a cell with NOW(), RAND() or RANDBETWEEN()”. I can fix this by changing the NOW() to today’s date, but the other graphs still don’t populate.

    I’m guessing this might have something to do with the fact that all my tweets come from within a very narrow time window (about half an hour)?

    Thanks in advance,
    Rob

    December 19, 2015 at 8:14 am #646

    mhawksey
    Keymaster

    Hi Rob, sorry for the delay. Looks like Google changed the way formula can be used in new Sheets. I’ve updated the dashboard to try and fix. If you delete the existing dashboard sheet and add back in via the menu it should work as designed

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.