Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the value with filter by variable without (SUM, COUNT, MAX)

Hello Everyone,

I have a table with a month number & month description (used to filter data)

NoMonths
1January
2Februar
3March
.....

In a variable I have the number of the month : (no selection = number of th current mont, >1 selection = max number).

=IF(GetSelectedCount(TIME_DESC)1,Month(Today()),IF(GetSelectedCount(TIME_DESC)>1,Max(TIME_MONTHUM),TIME_MONTHUM))

But I need to have the in a other or same variable the description of the month number

Something like this : (TIME_MONTHUM=$(=vPeriod),TIME_DESC)

How to get the value with filter (without any SUM, COUNT)

Best regards

1 Solution

Accepted Solutions
Not applicable
Author

I have resolve my issue with "ONLY"

only({$<DashboardID={$(vDashboardIDForced)}>}DashboardNameFR_DDB)

Thanks guys

View solution in original post

3 Replies
sunny_talwar

I don't think i understand your questions. Do you mind re-explaining what you trying to get?

Not applicable
Author

I have resolve my issue with "ONLY"

only({$<DashboardID={$(vDashboardIDForced)}>}DashboardNameFR_DDB)

Thanks guys

sunny_talwar

Awesome, I am glad you got it working. Please close this thread by marking your own answer as correct