Sign in to join the conversation:
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
If you click on the Edit button in the top left corner of the dashboard, you will be able to edit the widgets.
Hovering over a widget then clicking on the small pencil icon in the top right corner will allow you to edit the widget.
For chart widgets, clicking on the Edit Data button in the Chart & Data section (shown in the screenshot) will bring up a list of all sheets and reports that you have access to for use in a chart widget (this will be on the left of the dialog box that pops up). The sheet or report with the blue checkmark next to it is the one currently being used. GENERALLY speaking, if a sheet or report is already being used, the list of sheets and reports available for use will start with the sheet or report being used somewhere close to the middle of the displayed list as soon as the dialog box opens.
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
