Cognos Analytics

When I hover over the created at week (count) I receive a date instead of a number.  How do I change the date to a number?

​

------------------------------
Nancy Hartwick
------------------------------

#CognosAnalyticswithWatson

Hey Nancy,

Is this a dashboard or ? Also, could you provide more detail on how it's authored? How did you go about creating the "Created at week (count)"? I would like to test this on my end as well.

------------------------------
DENNY NAREZNY
------------------------------

Original Message:
Sent: 03-18-2019 09:25 AM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

When I hover over the created at week (count) I receive a date instead of a number.  How do I change the date to a number?

​

------------------------------
Nancy Hartwick
------------------------------

#CognosAnalyticswithWatson

Original Message------

Hey Nancy,

Is this a dashboard or ? Also, could you provide more detail on how it's authored? How did you go about creating the "Created at week (count)"? I would like to test this on my end as well.

------------------------------
DENNY NAREZNY
------------------------------

#CognosAnalyticswithWatson

I created a data module w/ sample of your data:
I created two calculations for week number - created and closed.
CrWeek, ClWeek - expressions are : _week_of_year ( Created_week )
This yields the week number - as seen in the image attached.
If you create a dashboard from the module the week number of created week and closed week are available.

Hope this helps.

------------------------------
Michael McGeein
------------------------------

Original Message:
Sent: 03-18-2019 12:47 PM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

Hi Denny,

I created the Dashboard and uploaded an excel spreadsheet to my content folder.  The following is a screen shot of the partial data.  If you like, would do a webex or zoom to demonstrate.  I am new to Cognos Analytics and am struggling a bit.  I have watched the youtube videos and have been reading on-line, but still need some 1x1 guidance.  



Thank you,

Nancy Hartwick
SABA Support Coordinator

18000 West Nine Mile Road
Southfield, MI 48075
nancy_hartwick@us.ibm.com
Phone:   1-720-430-0767 t/l: 912-0767

Original Message------

Hey Nancy,

Is this a dashboard or ? Also, could you provide more detail on how it's authored? How did you go about creating the "Created at week (count)"? I would like to test this on my end as well.

------------------------------
DENNY NAREZNY
------------------------------

#CognosAnalyticswithWatson

Original Message------

I created a data module w/ sample of your data:
I created two calculations for week number - created and closed.
CrWeek, ClWeek - expressions are : _week_of_year ( Created_week )
This yields the week number - as seen in the image attached.
If you create a dashboard from the module the week number of created week and closed week are available.

Hope this helps.

------------------------------
Michael McGeein
------------------------------

#CognosAnalyticswithWatson

Nancy:
What version of CA are you on? 
Based on the screen shot you shared you do not appear to have web based modelling enabled. 
The technique I provided uses Data modules, a core piece of CA .

------------------------------
Michael McGeein
------------------------------

Original Message:
Sent: 03-19-2019 02:25 PM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

Hi Michael,
Thank you for the information.  I tried to get to the data module from new and I don't see data module listed.

Next, I search for WeekNumberTests and Dates Wee...Testcase and was not able to find. 

Thank you,

Nancy Hartwick
SABA Support Coordinator

18000 West Nine Mile Road
Southfield, MI 48075
nancy_hartwick@us.ibm.com
Phone:   1-720-430-0767 t/l: 912-0767

Original Message------

I created a data module w/ sample of your data:
I created two calculations for week number - created and closed.
CrWeek, ClWeek - expressions are : _week_of_year ( Created_week )
This yields the week number - as seen in the image attached.
If you create a dashboard from the module the week number of created week and closed week are available.

Hope this helps.

------------------------------
Michael McGeein
------------------------------

#CognosAnalyticswithWatson

I have the following bookmarked:


------------------------------
Nancy Hartwick
------------------------------

Original Message:
Sent: 03-21-2019 02:26 PM
From: Michael McGeein
Subject: Under the Legend I receive a date vs a number

Nancy:
What version of CA are you on? 
Based on the screen shot you shared you do not appear to have web based modelling enabled. 
The technique I provided uses Data modules, a core piece of CA .

------------------------------
Michael McGeein

Original Message:
Sent: 03-19-2019 02:25 PM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

Hi Michael,
Thank you for the information.  I tried to get to the data module from new and I don't see data module listed.

Next, I search for WeekNumberTests and Dates Wee...Testcase and was not able to find. 

Thank you,

Nancy Hartwick
SABA Support Coordinator

18000 West Nine Mile Road
Southfield, MI 48075
nancy_hartwick@us.ibm.com
Phone:   1-720-430-0767 t/l: 912-0767

Original Message------

I created a data module w/ sample of your data:
I created two calculations for week number - created and closed.
CrWeek, ClWeek - expressions are : _week_of_year ( Created_week )
This yields the week number - as seen in the image attached.
If you create a dashboard from the module the week number of created week and closed week are available.

Hope this helps.

------------------------------
Michael McGeein
------------------------------

#CognosAnalyticswithWatson

Thanks for the info.
I created a dashboard from the uploaded file
I added 2 calculations to the uploaded data in dashboard.

_week_of_year ( DatesWeeksTestcase_xlsx.Created_week )
I did not duplicate your dashboard - but I think this is what you need.
see attached screen grabs - done on 11.0.13


------------------------------
Michael McGeein
------------------------------

Original Message:
Sent: 03-21-2019 02:33 PM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

I have the following bookmarked:


------------------------------
Nancy Hartwick

Original Message:
Sent: 03-21-2019 02:26 PM
From: Michael McGeein
Subject: Under the Legend I receive a date vs a number

Nancy:
What version of CA are you on? 
Based on the screen shot you shared you do not appear to have web based modelling enabled. 
The technique I provided uses Data modules, a core piece of CA .

------------------------------
Michael McGeein

Original Message:
Sent: 03-19-2019 02:25 PM
From: Nancy Hartwick
Subject: Under the Legend I receive a date vs a number

Hi Michael,
Thank you for the information.  I tried to get to the data module from new and I don't see data module listed.

Next, I search for WeekNumberTests and Dates Wee...Testcase and was not able to find. 

Thank you,

Nancy Hartwick
SABA Support Coordinator

18000 West Nine Mile Road
Southfield, MI 48075
nancy_hartwick@us.ibm.com
Phone:   1-720-430-0767 t/l: 912-0767

Original Message------

I created a data module w/ sample of your data:
I created two calculations for week number - created and closed.
CrWeek, ClWeek - expressions are : _week_of_year ( Created_week )
This yields the week number - as seen in the image attached.
If you create a dashboard from the module the week number of created week and closed week are available.

Hope this helps.

------------------------------
Michael McGeein
------------------------------

#CognosAnalyticswithWatson