3 Replies Latest reply on Dec 7, 2018 3:20 PM by Mavis Liu

# Filter Functionality in Dashboard?

I have a dashboard with 5 sheets. I have a Quarter filter(coming from sql code) which has values as All,Q1,Q2,Q3 and Q4 and this filter applies to all the 5 Sheets.My requirement is as below-

Month
Quarter FilterAll value selection in Quarter filter
Jan

X is a measure

Q1-Value displayed should be 'X/3'

Value displayed should be 'X/3'
FebQ1-Value displayed should be '2X/3'Value displayed should be '2X/3'
MarQ1-Value displayed should be '3X/3', which would be XValue displayed should be '3X/3', which would be X
AprQ2-Value displayed should be 'X/3'Value displayed should be '3X/3', which would be X
MayQ2-Value displayed should be '2X/3'Value displayed should be '3X/3', which would be X

and so on for another quarter and rest of the month. I can achieve this by parameter and then calculated field, but Quarter filter is applicable to all the 5 sheets and through parameter I dont think it can be achieved. Any suggestion please

• ###### 1. Re: Filter Functionality in Dashboard?

Hi Peeyush,

Please can you provide us with a sample workbook with dummy data?

Thanks,

Mavis

• ###### 2. Re: Filter Functionality in Dashboard?

Hi Mavis,

It's difficult to replicate the sheet with dummy data. But if you have some questions, please let me know.

Thanks,

• ###### 3. Re: Filter Functionality in Dashboard?

Hi Peeyush,

It's always easiest for us if you could provide a dummy workbook.

Because we're not sure what visualization you need this calculation to be in. So for us to re-create this and predict this for you it can be hard.

But just based on using normal dates and using the superstore dataset, I have created a calculated field to get the right 1,2,3 values against each month.

Using this field, you can then work out your final value.

Please see the attached workbook.

Thanks,

Mavis