Sign in to join the conversation:
I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.
Vramesh,
Without seeing your data structure and intended outcome it's harder for us to provide guidance or solutions. In general, the chart widget needs a data structure that is already summarized or aggregated and in a form of a table. Once you have the table, you can chart and then your viewers while viewing the chart can filter the view by clicking on any legend items (see example table below). You can summarize/filter your huge data set in a Sheet (via formulas, vlookup, cell links) or via a Report. Then you can target either the table in the sheet as your data source for the chart or target a Report and specific columns. Hope this helps.
Sasan
Does anyone know the best way to contact SS? I have been emailing for 2 weeks to get pricing and still have not had any luck. I need pricing to present the director when I propose using this sheet for project management but also don't want them to see the hassle it's been to get this going. usually this is the easy part.
Hello, my request form allows individuals to select teams that will participate on a project. And for each team, there may be multiple emails associated. My email list can grow quickly from from a few for some small projects to 50 individuals for larger ones. I have a datamesh running that copies the cell containing the…
Hello, I'm trying to create an Approval Request automation, but I need the following actions: When approved: for user to type out their name When declined: for used to type out a reason I'm able to select the columns I want the information to be populated in on the automation, but it shows an error message. Is there no way…
