Dynamic date stamp on dashboards | XM Community
Skip to main content

Hi there,
I've been asked to add a date stamp to recurring reports, for example "Data from xx/xx/xxxx to xx/xx/xxxx" but I see no widget that can do this, nor dynamic text that can be inserted.
Is there any way? If no, how can I request this feature?
Thanks all in advance.

If I'm understanding it correctly, You can apply filter globally using record date variable. Else please check this with Qualtrics support.


Hi ArunDubey,
Thanks for taking the time to reply.
With your solution, say for example you are scheduling a weekly dashboard, and filter the date by 'this week, shifted back by 1 week', that wouldn't add the date itself to the dashboard. Instead, that would look like this:.
image.pngSo the viewer wouldn't know what date the data corresponds to.

Cheers


Hi CristianPinzetta , please refer below screenshots. PS. I'm using date variable Record date for date range filter. Make sure your custom variable type should be date variable in the backend of the database.
image.png
image.png
image.png
image.png


Hi,
These dashboards will be viewed periodically, therefore with your example I'd need to change the date manually every week.
Thanks though.


Yes, if you want to keep it dynamically then date range will not appear and it will show like last 30 days, 60 days etc.


CristianPinzetta - I could see this being really helpful! If you want to submit a product idea, here's the link to do that: https://community.qualtrics.com/XMcommunity/categories/product-ideas. If you do, share the link here and I'll upvote it!


Hi Cmurph,
Thanks for the link, I've just added the idea: https://community.qualtrics.com/XMcommunity/discussion/23768/dynamic-automatic-date-stamp-in-dashboards#latest
Cheers
Cristian


Hi CMurph and CristianPinzetta
I think you can do this already by using a widget and displaying recorded date, perhaps group it to week and then just adding a filter to show the last 7 days or something like that and then just mess around with the various settings to make it not show anything else . I use this line widget for my dashboards and it works quite well. Sometimes it displays 2 weeks but not very often.
Hope that helps
image.png
I have also raised a similar product idea about timestamps but it's more about when the cache for the data was last refreshed which sometimes goes wrong I've discovered. WOuld be grateful for some upvoting https://community.qualtrics.com/XMcommunity/discussion/23068/cx-dashboard-widgets-timestamp-when-background-data-last-updated#latest
Thanks

Rod Pestell


Hi ​@CristianPinzetta, ​@CMurph, ​@ArunDubey  and All,  It’s been some time since I wrote here but the table widget idea is still in use for my dashboards however, now that Qualtrics offer a means to export the dashboard in csv format (WYSIWYG style) meaning you don’t have to copy paste the web page to get the data into excel, the time stamp table idea needs to be changed as otherwise it will display all the dates for all the records used in the dashboard page.  So my idea is to convert the date to a decimal number, yyyymm.dd or if you need a time yyyymmdd.hhmmss for example.

 

In the dashboard this can then be setup as a number set / number value and then you can use the max metric and only get one value appearing.  That sounds like it will work?!

 

Problem is how best to convert all retrospective date.  My thinking is you create a new field in the survey flow, then export all responses with just the responseID and recorded date and the new field.  then In excel use a vba script to work through batches of response IDs and populate the new field from a column in excel having converted the date to a number value in excel (using the setting that doesn’t update the recorded date field!!) oI have created a VBA script which does that].

 

So that’s the back data done.  The next step would be how to populate the field within Qualtrics when a response comes through.  Any thoughts?

 

Thanks

 

Rod Pestell


just had another thought…. (linking to this thread which is also talking about a similar thing… 

 

 

Using a format of yyyy-mm-dd in the survey data field in a dashboard it is possible to add it in and change the field type to a number set.  you can then (painstakingly) add a mapping for each day and convert eg. 2019-04-22 to 20190422 (or 201904.22).  You can then use a Max metric in a table widget which will then show this value.  So that in some sense gets round the need to change any data retrospectively, however… qualtrics though it would be nice to inject a comma spliting it by thousands so you end up seeing 201,90,422.

 

So I’m 90% of the way there but the format is the issue now!  Doing any sort of API or export, amend the data and then uplaod would result in the same issue with the commas I’d say so I need to find out how best to display this number with the ability to still use the MAX metric.

 

Any thoughts most welcome

 

Thanks

 

Rod Pestell


Leave a Reply