I followed this post to create the date comparison table. Instead of showing this month/ this year, is there a way that we can automate to let the column to show the real date, like 2022 Oct(this month)/ 2022(this year)?
Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…
December 2, 2022, 7:01pm
The only way I could think would be to use parameters and set dynamic default values.
Currently the solution is to create a dataset that is refreshed daily and which keeps the value of today’s date. Then you can use this dataset to set up a dynamic default for the parameter. You can see the last section here on how to set up Dynamic Default Parameters:
You need to keep in mind that for dynamic defaults you need to provide a username or a groupname. So you, in your dynamic defaults dataset, you would need to create a group for all users or else keep adding all your users into th…