• Replies 4 replies
  • Subscribers 0 subscribers
  • Views 16 views
  • Users 0 members are here
Options
3sides - Social sharing widget
Related

Question: is there a way to filter a view by current year?

Maria Sarra
27260

Hello,

I have this iSheet with one datetime column, and in the reporting I have some dashboards that show the data by period (for example, by month). But I want the dashboard to just show the data from the current year, and not show in february the data from this february and february from the past years.

I know I could filter it in the view saying that the date is later than 1st january 2022, but then I would have to update it each year. Is there a way to somehow indicate that the date corresponds to the current year? so that the dashboard shows the correct data automatically?

Thank you very much!!

Parents

  • We've built our own replacement for core KPI cards now which has to deal with the concept of this/last week/month/year to achieve this - not the best solution as it's development overhead but seems to be the only way to achieve these without having someone go round 2000 sites each week/month/year and update the views heh.

Reply

  • We've built our own replacement for core KPI cards now which has to deal with the concept of this/last week/month/year to achieve this - not the best solution as it's development overhead but seems to be the only way to achieve these without having someone go round 2000 sites each week/month/year and update the views heh.

Children
No Data