CODEWITHSUNDEEP
datefilterdefaultspotfire
BULB
BULB

Reputation: 143

Month filter to be defaulted to current month whenever user opens the report

I have a month column in the data and I am adding this as a filter so that user can filter whichever month he wants.

I want the month filter to be defaulted to current month whenever user opens the report and then he can change the month based on his needs. Is this possible in spotfire?

Upvotes: 0

Views: 749

Answers (1)

Jacek Sierajewski
Jacek Sierajewski

Reputation: 633

You can create the calculated column with the following definition and pick current month as a filter.

If(Month([Date])=Month(DateTimeNow()),"Current month",String([Date]))

Upvotes: 1

Related Questions