Hi Team, I’m trying to add a dynamic month in my table title that updates based on a parameter, but it’s not working. I created a parameter called ${CurrentMonth} and a calculated field with this formula: concat(formatDate(${CurrentMonth}),'MMM'),'-',formatDate(${CurrentMonth}),'YYYY'),' ',"Summary Report")) but it’s throwing errors. I want the title to display something like “Jan-2024 Summary Report” and update automatically. Can someone help me with the correct syntax or suggest a better approach to show a dynamic month in the table title? Any working examples would be really helpful. Thanks!
Hi @ddoniken and welcome to the Quick Suite Community!
If you’re trying to edit your title to show your parameter values, there is an easier way than trying to do through a calculated field. When editing your title (or subtitle), there is an option to add your dynamic parameter value:
Let me know if this is what you’re looking to achieve or something different
Hi @Brett , thanks for your reply! I tried the solution, but I’m running into an issue. Instead of displaying “Jan-2024 Summary Report” as expected, my table title is showing “All-Summary Report”. It seems like the date parameter isn’t being recognized or is returning “All” instead of an actual date value. Any idea what might be causing this or how to fix it?
Hi @ddoniken,
When using the solution I suggested, this will automatically pull in the value that’s currently selected in your parameter. So if ‘All’ is selected, that is what it will present in the title. Could you share some additional information about your parameter; are you using custom values or values from a dataset field? How many value options are there? What’s the format of the values?
Hi @ddoniken,
Following up here as it’s been a while since last communication took place on this thread; Were you able to see Brett’s most recent most and/or find a solution yourself in the meantime?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Thanks for following up. I’m sharing the approaches I’ve tried:
My Parameter Setup:
-
Parameter Name:
CurrentMonth -
Data Type: DateTime
-
Default Date: Relative Date(Start of this month)
-
Values: Single value
Another way
Parameter Name: ReportMonth
Data Type: String
Calculated Field : formatDate(${CurrentMonth},‘MMM’)
Hi @ddoniken,
Glad you were able to somewhat get the formatting of the title correct despite it now showing respective Month-Year. Although in your most recent post you show that you set parameter to start of this month, I believe the reason it is showing “All” is because there is no filtering for your Date field.
Could you try adding a Date filter to your desired visual like this:
Adding a relative date filter set for “This month” along with connecting a respective Date parameter I believe should adjust your title.
If that does not work though, you can definitely get your visual to work behave how you want, but I do not think the title itself will be able to reformatted that way since parameters do not allow you to use formatDate. Let me know if this helps!
Hi @ddoniken
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @ddoniken
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!