Can I add a date selector by months?

716
2
08-25-2020 01:45 PM
AsafEvenPaz
Regular Contributor

I have a table with several rows of data for each month of the year and I want to display it in the dashboard giving the user the option to filter by month. I know there is the data picker but when I try to add it and apply an action it doe snot seem to filter the correct results. Any ideas? 

0 Kudos
2 Replies
ryanEvanczyk
Frequent Contributor

I have a dashboard displaying seasonal snow data. I want to be able to look at the historical averages by winter and month and calculate % of average.

An indicator can calculate the average per time period based on the date selector, but then I only see the average amount of snow for that specific date range, not over the 30-years of data.

I can define date options for months, but it seems tedious to choose every May for the past 30 years. Is there a way to custom define date ranges more easily?

ryanEvanczyk_0-1659471702520.png

 

0 Kudos
ChelseaRozek
MVP Regular Contributor
0 Kudos