Smartsheet reporting and dashboard
Attached below is a screenshot of a Smartsheet dashboard that we have had set up on our project by someone else. The dashboard data is being driven by a report which is in turn being driven by a stats sheet (screenshots also attached below). I have a couple of questions in relation to setting up a different dashboard that will use a similar sort of approach:
- While creating the new SS dashboard and then selecting the chart widget, I am unable to make it display the information displayed in the report. I want the information shown in the report to reflect in the chart widget (as shown in the attached DCM Dashboard image).
- In the stats screen shot below, do you know what is the purpose of having a Rpt-Level column and the formula associated with it?
Please ask if you don't understand the above queries. Thanks.