How to Display "Rental Days for the Month of [Month]" in an Automated Email

Question & Answer
,
1

Hello QuickSight Community,

I’m working on an automated email report in QuickSight, and I’d like to include a calculated field in the email that displays a dynamic message such as: “Rental days for the month of [Month].”

The goal is to have the month automatically update based on the reporting period (e.g., if the report is for July, the text would be “Rental days for the month of July”). How can I create a calculated field in QuickSight to achieve this?

Thank you for your help!

2

Hi @Gpadilla

Welcome to the community!

To create a dynamic message that updates the month automatically based on the reporting period, you can use a combination of calculated fields.

Example : Calculated Field 1

ifelse(extract('MM', {Your Date Field}) = 1,'Jan',
                    ifelse(extract('MM', {Your Date Field}) = 2,'Feb',
                        ifelse(extract('MM', {Your Date Field}) = 3, 'Mar',
                            ifelse(extract('MM', {Your Date Field}) = 4, 'Apr',
                                ifelse(extract('MM', {Your Date Field}) = 5, 'May',
                                    ifelse(extract('MM', {Your Date Field}) = 6, 'Jun',
                                        ifelse(extract('MM', {Your Date Field}) = 7, 'Jul',
                                             ifelse(extract('MM', {Your Date Field}) = 8, 'Aug',
                                                ifelse(extract('MM', {Your Date Field}) = 9, 'Sep',
                                                    ifelse(extract('MM', {Your Date Field}) = 10, 'Oct',
                                                        ifelse(extract('MM', {Your Date Field}) = 11, 'Nov',
                                                            ifelse(extract('MM', {Your Date Field}) = 12, 'Dec',
                                                            ''
                                                        )
                                                    )
                                                )
                                            )
                                        )
                                    )
                                )
                            )
                        )
                    )
                )
            )

Example : Calculated Field 2

concat('Rental days for the month of ', {Above Created Month Name Calculated}, '.')

Please refer the below documentation for email report and scheduling it.

Hope this helps!

3

Hi @Gpadilla,
It’s been awhile since we last heard from you, were you able to find a work around for your case from the solution provided above or did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @Gpadilla,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information that may be needed.

Thank you!