Creating a parameter label title with quarter and year

Question & Answer
,
1

Hello, I’m new to development and trying to create a label for my dashboard report that shows Quarter and Year of the range of the report so users know for what range that report is covered. I can show a filter but having issues showing in a title or label. Here is my calculated field.

concat (‘Q’ , toString( extract ( ‘Q’, Measuredate)) , ’ ', toString(extract(‘YYYY’, Measuredate)) )

Does anyone know how to express this in a title? Or ever a text box as a parameter?
Thanks
Patrick

2

Hi @Pforbes and welcome to the QuickSight community!

Using a parameter would be the most ideal way to achieve this. Once you’ve setup your parameter(s) you can either add the parameter value to your title or a text box. In either option, they’ll be a parameter button like below:

image

Select the correct parameter and it will populate with the value your parameter is set to.

Let me know if this works for your case or if you have any additional questions!

2 Likes
3

Hi @Pforbes,
Checking in to see if you had any additional questions regarding your initial topic?

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 @Pforbes,
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 if needed.

Thank you!

5

Thanks , that did the trick!

2 Likes