Reply To: Dashboard brokenness, particularly on public views

Home Forums TAGSExplorer Questions/Issues Dashboard brokenness, particularly on public views Reply To: Dashboard brokenness, particularly on public views

#382

mhawksey
Keymaster

Hi Su – for the chart top left there seems to be a weird bug where if you open the chart to edit, click update without making changes it works. The REF! error is because it filters for the last 24 hrs and if it has no results it falls over. You can specify a date for archives that aren’t collecting still by changing cell Dashboard!F26 to include a fixed date (this was for the 2nd March 2015):

=filterUnique(FILTER(Archive!A:C,Archive!E:E>(DATE(2015,3,2))))

as per this example

Best wishes
Martin