Dashboard default filter

[didierodayo]

Hello all,

I have a dashboard running slow because of the it is loading close to 80million records. A chart on the dashboard has student_id  and start_date as dimension My question is the following

How can I force users to select Month/Year on opening if they would like to view the data based on all student_id.

If the user doesn't want to analyse all the records then HOW can I allow them to switch from MonthYear default filter to Student_ID?

This is because the document is faster when 1 or few student_ids are selected OR when the MonthYear date is selected from the dynamic calendar.

I really welcome any suggestion.

Thanks

[MindaugasBacius]

Try using triggers for fields Year and Month.

Also, you could Lock the fields.

Besides, if dashboard contains multiple tabs consider using OnLeaveSheet action Clear All.

[susovan · Accepted solution]

Hi,

First of all do this thing for the sheet.

Please find the attachment for QVW file.

[nilapril2010]

Simple

In expression condition write the following condition

GetSelectedCount(FieldName) > 0

If user make any selection, the GetSelectedCount(FieldName) will be possitive and your chart expression will be executed. Otherwise your chart expression will not be executed.

Regards

Nilanjan

[chetanpatel]

Where you passing value =MAT