Jump to content
  • 0

Show Seasons



3 answers to this question

Recommended Posts

  • 0

Hello @SuperNam,

You can try creating a Formula or calculated value/field then insert the code below.

CASE WHEN ( (Month('[@cbParamVirtual1]')) >= 3 )

AND ( (Month('[@cbParamVirtual1]')) <= 5 )

THEN  'Spring'


 WHEN ( (Month('[@cbParamVirtual1]')) >= 6 )

AND ( (Month('[@cbParamVirtual1]')) <= 8 )

THEN  'Summer'


 WHEN ( (Month('[@cbParamVirtual1]')) >= 9 )

AND ( (Month('[@cbParamVirtual1]')) <= 11 )

THEN  'Fall'


 WHEN ( (Month('[@cbParamVirtual1]')) <= 2 )

OR ( (Month('[@cbParamVirtual1]')) = 12 )

THEN  'Winter'




Link to comment
Share on other sites

  • 0

I agree with Natoy, you can use CASE statements with this. However, 

Regarding on the SQL Queries, I believe it is not directly. But we can create a View to join the tables, then create a Report DataPage to retrieve data from this view, in which we can apply further filters. You may write SQL Statements to do subqueries from the results returned by your Report DataPage. Also, SQL Statements can be used in tables, and calculated values.

This video from Caspio helped me as well about using SQL in the Bridge : 

I hope this helps. Cheers! 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...