• 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

  • Maria Sarra So writing our own JS that'd find specific tags we'd created e.g



    Then the JS would take those data attributes, query the XML feeds of the iSheets and then do the filtering based on the date column, filter type and period and then inserting appropriate HTML/CSS into the tag.

    It's about as low code as we can achieve, but it's not a full replacement that you'd be able to give to everyone for using on their sites.

Reply

  • Maria Sarra So writing our own JS that'd find specific tags we'd created e.g



    Then the JS would take those data attributes, query the XML feeds of the iSheets and then do the filtering based on the date column, filter type and period and then inserting appropriate HTML/CSS into the tag.

    It's about as low code as we can achieve, but it's not a full replacement that you'd be able to give to everyone for using on their sites.

Children
No Data