Hello All - I have a dashboard where we need to dynamically name columns based on field in the data. e.g. if max run date is today it should show previous Week number in pivot table header

Question & Answer
, ,
1

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.

2

Hi @BharathBhushan,

you can achieve that by set up a parameter and use it in ā€œvalue namesā€ in the pivot table.
image

Maybe this also helps: Dynamic column names

BR
LKS

4 Likes
3

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!

4

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
5

Hi @BharathBhushan,
Did you setup a default date for your parameter? That way it wonā€™t default to ā€˜Allā€™

image
image1299Ɨ1226 62.4 KB

1 Like
6

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

7

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.

image
image600Ɨ1007 46.9 KB

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

1 Like
8

Hi @BharathBhushan,
Itā€™s been awhile since we last heard from you so following up here to see if you have any remaining questions?

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

Thank you!

9

Hi @BharathBhushan,
Since we havenā€™t heard back, Iā€™ll 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!