Dynamic dashboard using year wise data

Yashwant Singh

Hi,

In smatsheet how to create year wise dashboard.

User select year and chart graph change dynamically as per year data.. it's possible using smartsheet ?

Genevieve P.

Hi Yashwant,

There currently isn't a way for the user who is looking at the dashboard to adjust what year the data in a chart widget shows.

You would need to create multiple charts or graphs that display each year's data so that the user can scroll and see which chart they want to see. Does that make sense?

Here are a few articles that may help you:

• Chart Widget
• Dashboard Best Practices Webinar (Preparing Data)
• Dashboard Best Practices Webinar (Building & Designing)

Cheers,

Genevieve