Hide Text Box when Month AND Year are selected?

[stjernvd]

When the user selects a month and several years OR when the user selects a month and NO year is selected the graph looks like this:

The reason being that you can't see results linearly from one month across several years.

I would like to have a text box that tells the user that when they select just one month they must only select one year at a time, or when they select a month and no year is selected they must select a year (one at a time).

And then when they have selected these two conditions, the text box should disappear.

Sorry if this is asking too much at once but would be so helpful.

Danielle

[sunny_talwar]

Create a text box with whatever you want your readers to see and conditionally show hide the text box with a condition like this may be:

not (GetSelectedCount(Month) = 1 and (GetSelectedCount(Year) > 1 or GetSelectedCount(Year) = 0))

not (GetSelectedCount(Month) = 1 and GetSelectedCount(Year) = 1)

EDIT: Attaching a sample

[swuehl · Accepted solution]

Something like

=If( GetSelectedCount( Month ) =1 and GetSelectedCount( Year ) <>1, 'Please select a single year')

In the layout tab of the text box, use a conditional show:

=GetSelectedCount( Month ) =1 and GetSelectedCount( Year ) <>1

edit:

Of course, if you use a conditional show, you don't need the condition in the text expression.

[stjernvd]

thank you!

[stjernvd]

Thank you so much!