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
Hi all. Hoping this is pretty basic here. I had to do a find and replace on a few numbers in a Smartsheet grid which changed them to a different "format" (not sure if thats the right word) from the others. I've since ran a Vlookup on the column, and the converted numbers come up as no match. I believe this is the same…
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…
Is there a way to make a 4 button by 4 button panel to collect data for tallying? Basically, I have an operator performing 1 of 16 different tasks, and I simply want them to tap the button for the specific task completed. I would want something like this opposed to a pull-down menu and submit button.
