I have a weekly report where I want to dynamically rename headers based on Run date field in the dataset. This I want o use in Header for Pivot table.
Hi @BharathBhushan,
you can achieve that by set up a parameter and use it in âvalue namesâ in the pivot table.
Maybe this also helps: Dynamic column names
BR
LKS
4 Likes
Hi @BharathBhushan,
Itâs been awhile since we last heard from you; did you have any additional questions regarding your topic?
If we do not hear back within the next 3 business days, Iâll go ahead and close out this topic.
Thank you!
Hey I tried this my data has a field which is last refresh date I need to create parameters relative to this field. Essentially use this field as a parameter for the heading in my pivot table. e.g. if last refresh date is 9/21 (week 38) can I use that to create a parameter that can be used in header as either [Week 38], [week 37] and so on⌠or as [week ending 9/21] [week ending 9/14] so onâŚ
I tried using parameter from field but every-time dashboard loads it defaults to all which manually has be selected to the date/week number then all calculations happen which is a poor CX
1 Like
Hi @BharathBhushan,
Did you setup a default date for your parameter? That way it wonât default to âAllâ
1 Like
Hello Thank you I tried this and set 2099-12-31 as the default date and everytime dashboard reloads it is defaulting to this date instead of a date of last saturday which is the requirement
Hi @BharathBhushan,
If you set a date as your default date, the dashboard will reload to that because it is the default value.
What if you tried switching to ârelative dateâ instead of âfixed dateâ, then you can change your selection(s) to âstart ofâ, âpreviousâ, and for period choose âweekâ.
Then, you can go in to your analysis settings (under âEditâ on the top menu bar), you can change which day of the week is your start day.
Let me know if this works for your case or if you have any additional questions.
1 Like