I have a number of date dimension groups which are great for representing flexible date reporting.
The problem however is that when I select a filter for it, the filter is always represented by the full dd/mm/yyyy format.
E.G.
Start Date = 01-01-2022
Start Date Month = 2022-01
Filter selected requires specific day input, cannot select a specific month without defining a range .
If you could possibly help me I would be greatly appreciative.
Kind Regards,
Connor
Solved! Go to Solution.
Hi Connor!
Please check this example that I think it will help:
1.- Make sure we are using a dimension group working properly (Apply CAST functions of your SQL Dialect if needed)
2.- Locate the dimension group created and select month option
3.- Customize the selection depending on your requirement
4.- Example of the filter generated:
Hope this helps!
Best regards,
Leo