Dashboard error

[Robert de Vries]

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

[mhawksey]

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