Forum Discussion
how to display text message if we have no data for certain quarters
Is there a way to display text message if we have blank data for certain quarters like "There is no data available for the range selected" or "There is partial data available for the range selected" for certain quarters when we are comparing sales of two years with same quarter like Q1-2024 to Q1-2023 in bar chart?
| QQ-YYYY | sales | Date |
| Q1-2023 | 62 | 12/15/2022 |
| Q2-2023 | 98 | 3/15/2023 |
| Q3-2023 | 55 | 6/15/2023 |
| Q4-2023 | 9/15/2023 | |
| Q1-2024 | 12/15/2023 | |
| Q2-2024 | 65 | 3/15/2024 |
| Q3-2024 | 83 | 6/15/2024 |
| Q4-2024 | 9/15/2024 | |
| Q1-2025 | 12/15/2024 | |
| Q2-2025 | 3/15/2025 | |
| Q3-2025 | 58 | 6/15/2025 |
| Q4-2025 | 75 | 9/15/2025 |
1 Reply
- lbendlin
Super User
what would be the business value of that text message? Are you afraid that your report users will misinterpret the data?
