Hi,
Currently I’m working with a data set that gives me a response date for a Net Promoter Score (When a User has reviewed a web page). The format is given to me in MM/DD/YYYY HH:MM:SS AM/PM.
I tried working with the Data & Time functions that Dundas gives automatically, but I’m not received the type of information I need to work at a granular level. Is there a way to transform this Response Date into:
Week # (i.e. the number Week of the year)
Year
This is a transform we currently do in Excel.
Hi Mario,
You can use the built in formatting on the dashboard/report rather than trying to change the formatting in the data.
Here is a great article to get you going.
https://www.dundas.com/support/learning/documentation/analyze-data/formatting-text
Keep in mind that you can potentially change the formatting in two places.
By the way. Week number is something that is built into the Time Dimension that I mentioned above. If you add week to your dimension, you will see formatting options for it.
(select the time periods you want to use)
Hi Jeff,
I created the time dimension I’d like to use based on the information you gave me above, and I’m having trouble trying to drop it into my metric set.
I’m getting the attached message when I try to drag it over and drop. Is there a step I’m missing?
Hi Jeff,
I created the time dimension I’d like to use based on the information you gave me above, and I’m having trouble trying to drop it into my metric set.
I’m getting the attached message when I try to drag it over and drop. Is there a step I’m missing?
Hi Mario,
That message can come up if you’re trying to use a time dimension in a metric set based on a data cube that you or someone else created ahead of time. In that case you’ll need to go back to that data cube editor to make use of time dimensions and hierarchies in its Process Result transform.
https://www.dundas.com/support/learning/documentation/cleanse-consolidate-modify-data/transforms/output/process-result#h1-2-1-replace-with-a-hierarchy
You’re able to just drag and drop a time dimension onto a metric set if you had similarly just dragged and dropped data directly from a data source, which “auto-generates” a data cube and allows you to bypass using the data cube editor.
Jamie
