Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
So I want to set a button to select quarters of different years.
I am doing the following:
As action I select : "Select values matching search criteria" , then I have to select the field. I need to select [Posting Date.autoCalendar.YearQuarter] (((is the category I used to build the graphs))
but when I go through the list of categories that I can pick, it does not apper. Why? how can I solve this?
Hello,
When when you select the option "Select values matching search criteria" then you only have the options to select the dimension as it is. The search criteria is looking for values that match the string that you supply. For example:
1. If your dates look like: 'M/D/YYYY' then you can use in search ='10/1/2026' and it will select all the rows where the date field is exactly '10/1/2016', if you type ='*2016', then it will select all the rows where the date field has 2016 at the end etc.
2. Now the Posting Date.autoCalendar.YearQuarter value looks like 'YYYY-Q#' which means that you will not be able to match it with the search criteria as you need it.
3. My recommendation would be:
Perhaps there are other ways as well to resolve this issue or use other workarounds, but this is what worked for me.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Hello,
When when you select the option "Select values matching search criteria" then you only have the options to select the dimension as it is. The search criteria is looking for values that match the string that you supply. For example:
1. If your dates look like: 'M/D/YYYY' then you can use in search ='10/1/2026' and it will select all the rows where the date field is exactly '10/1/2016', if you type ='*2016', then it will select all the rows where the date field has 2016 at the end etc.
2. Now the Posting Date.autoCalendar.YearQuarter value looks like 'YYYY-Q#' which means that you will not be able to match it with the search criteria as you need it.
3. My recommendation would be:
Perhaps there are other ways as well to resolve this issue or use other workarounds, but this is what worked for me.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Dude, thank you so much!!
It did help!