7 Replies Latest reply on Sep 10, 2018 6:03 AM by Fabien Epiney

# Dashboard: Using some filters on same values

Hello community!

I've got a problem that I can't fix and it's annoying.

I've got datas which contains some dimension using dates which are différents (Date of creation, Date of use, Date of sell, etc...). In my Dashboard, I want to put a filter filtering the year 2017 for all the dimensions that I've spoken before.

I don't know if it's possible to do such a thing and I wanted to ask the experimented people of the community!

Thanks a lot for the response,

Epiney_9

• ###### 1. Re: Dashboard: Using some filters on same values

You can try:

Calculation =

(YEAR(DATE1) = 2017

OR

YEAR(DATE2) = 2017

OR

YEAR(DATE3) = 2017)

drop that on filer shelf and select 'true'

You can replace the 2017 above with a parameter.

Call it 'Year of Date'.

Then change the calc above to

Calculation =

(YEAR(DATE1) = [Year of Date]

OR

YEAR(DATE2) = [Year of Date]

OR

YEAR(DATE3) = [Year of Date])

Drop calc on filter shelf -> filter to 'true'.

then show parameter. Now you can look at different years if needed.

• ###### 2. Re: Dashboard: Using some filters on same values

Create calculated field as following and place it on filter pane and select 'True'.

YEAR([Date1]) = 2017

AND

YEAR([Date2])= 2017

and so on

• ###### 3. Re: Dashboard: Using some filters on same values

Thank you everybody! I'll try this solution this night!

Have a nice day everybody!

• ###### 4. Re: Dashboard: Using some filters on same values

No problem.

-John

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 5. Re: Dashboard: Using some filters on same values

Hello Community! Thank you for the help.

I've tried the answer and it work well, but the datas aren't correct: The use of "OR" involve a over-representation and the use of "AND" involve an under representation of the data.

So, maybe you'll have the answer of that question:

I've 3 different sheets, which one using a filter based on one date (Date 1 for sheet 1, Date 2 for sheet 2, Date 3 for sheet 3). I'm trying to write a calculated field which will be like this but I don't know if it exist. In fact, I'd like to select the filter according to the sheet and put the parameter on my dashboard to avoid the use of 3 filters (Date1,Date2,Date3) and have only one (YEAR).

IF SHEET = SHEET1 THEN DATE1 = [YEAR]

ELSEIF SHEET = SHEET2 THEN DATE2 = [YEAR]

ELSEIF SHEET = SHEET3 THEN DATE3 = [YEAR]

ELSE

END

[YEAR] is the parameter defined by John Croft 3 days ago!

Thank you for your time everybody!

• ###### 6. Re: Dashboard: Using some filters on same values

Keeping Year as your parameter, define 3 calculated fields:

Sheet 1 Calc:

[YEAR] = YEAR([DATE1])

Sheet 2 Calc:

[YEAR] = YEAR([DATE2])

Sheet 3 Calc:

[YEAR] = YEAR([DATE3])

For each Sheet, drag the appropriate calc to the filter shelf and filter to 'true'. Now each time you change the parameter you should obtain the appropriate representation on each sheet.

Let me know if that does not work.

-John

1 of 1 people found this helpful
• ###### 7. Re: Dashboard: Using some filters on same values

Thank you!
After short time, I've found the answer!

Have a nice day