Hello. I would recommend binding a parameter to your month filter! Start by going to the parameters tab and creating a new parameter: Next, toggle on multi select button, select the column value from the available values, and select month from the drop down. In the initial value drop down, select Logical SQL Query. Input…

Hi there! We encountered this same issue in the past. Here's a forum post I created about it. We created custom dataset then joined it to Workforce core on person number. This is the query we used: SELECT "HCM - Workforce Core"."Basic Information"."Person Number", CASE WHEN COUNT(DISTINCT "HCM - Workforce…

Not sure which subject area you're using, but using Workforce Core I was able to successfully get the current and future 4 years using the following expression filter: "HCM - Workforce Core"."Time"."Year" >= YEAR(CURRENT_DATE) AND "HCM - Workforce Core"."Time"."Year" <= YEAR(TIMESTAMPADD(SQL_TSI_YEAR, 5, CURRENT_DATE))

Does the column Manager User name exactly match the value in User Name? For us, for example, Manager user name column is like "Blanchard, Caroline" versus Display Name column is "Caroline Blanchard". We had to use a custom calc to flip things around because the match has to be exact. What do you mean use it directly, like…

Hi @JT_DC_2023, our organization has successfully used parameters to create dynamic filters of the logged in user using the binding parameters feature. What we did was put in a filter from the out of the box data for example, Display Name out of workforce core and bound to the out of the box parameter Display Name. This…

@Roelof de Groot In the use case you mentioned above, I'd recommend using binding parameters across the dashboard filters on separate canvases. If you have a dashboard filter across three canvases you can bind it to a parameter and if the end user changes the value, it will change in the other canvases as well so long as…

@Matt Milella-Oracle @Jamie Anderson-Oracle This is exactly what I was looking for!! The documentation example is very helpful. Thank you so much!

I second this idea, this is something we need at our organization as well!

Logged an SR about this issue and it was solved. Basically, if your tile metric has a description in there it will cause the stuck in top row issue. To fix it you go into your custom calculation and delete the description. If using an out of the box calculation that has a long definition, you'll have to create a custom…

@Krishna Prasad Kotti-Oracle Bringing in all the values of the custom column (in this case 4 or 5 values maximum) is exactly what I want it to do.