List of Contributions

Leif Glaes

Contact Details

My Content

1 to 16 of 16 total

RE: Extract hour:Minute from timestamp

Posted By Leif Glaes Mon May 09, 2022 02:37 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! Thank´s, I will try the different solutions. What I forgot to write in my question is that I´m using the solution in a Dashboard. I don´t know if that changes your solutions? Vänliga hälsningar Leif Glaés ------------------------------- Utdata/analys, kommunikationsstöd Verksamhetsområde ...

RE: Extract hour:Minute from timestamp

Posted By Leif Glaes Mon May 09, 2022 02:21 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! Thank´s, I will try the different suggested solutions What I forgot to write in my question is that I´m using the solution in a Dashboard. I don´t know if that changes your proposed code-solutions? I´m trying to get the endtime (how many ends at a certain time) for our surgerys per ...

Extract hour:Minute from timestamp

Posted By Leif Glaes Fri May 06, 2022 03:47 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! How do I do to extract hour:minute from a timestamp of this format: 2022-04-12T11:30 I have been able to get hours with (ex 16, 17..) my current formula: extract(hour; [Peroptider].[Peroptider].[Tidpunkt] ) But i want to get the combination of hour and minute (like 16:30, 17:25..) ...

RE: Cognosproblems after installing patch log4j

Posted By Leif Glaes Thu March 17, 2022 10:09 AM
Found In Egroup: Cognos Analytics \ view thread
Hi I am not a techguy, I am just a end-user/developer.

Cognosproblems after installing patch log4j

Posted By Leif Glaes Thu March 17, 2022 09:29 AM
Found In Egroup: Cognos Analytics \ view thread
Hi! Is there any one of you who has got problems in Cognos Analytics (11.1) after installing the patch log4j Security Vulnerabilities on your servers? We are having issues with the Cognossystem going down, getting slow - lagging. Server restart only helps temporarily. I´m not all sure that it depens ...

RE: Merge two timestamps

Posted By Leif Glaes Thu September 16, 2021 06:13 AM
Found In Egroup: Cognos Analytics \ view thread
Thank´s Philipp Hornung, I will try out this solution. ------------------------------ Leif Glaes ------------------------------

RE: Merge two timestamps

Posted By Leif Glaes Wed September 15, 2021 06:08 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! Trying to clarify my request. I have two dashboards from the same source. Dashboard nr 1 is showing the numbers of incoming X-ray remiss per month, distributed per hour (exampel: during the month of august there were 112 incoming X-ray remiss at two o´clock and 155 at tree o´clock). In this dashboard ...

Merge two timestamps

Posted By Leif Glaes Wed September 15, 2021 06:36 AM
Found In Egroup: Cognos Analytics \ view thread
Hi! From a datasource I have two different timestamps that I would like to merge into one. I have [UsStartTidpunkt] and [RemissInlästTidpunkt], is there any way that you can get these two in to one time (hour) by using a calculation with extract(hour; or is there a another way to do this? I´m planning ...

RE: Removing filterbar from Dashboard

Posted By Leif Glaes Sun January 31, 2021 08:38 AM
Found In Egroup: Cognos Analytics \ view thread
Thank´s Jeremy, I now have given it my vote :) ------------------------------ Leif Glaes ------------------------------

RE: Removing filterbar from Dashboard

Posted By Leif Glaes Sun January 31, 2021 08:36 AM
Found In Egroup: Cognos Analytics \ view thread
Thank´s for your answer, but as you say "Not a optimal way". ------------------------------ Leif Glaes ------------------------------

Removing filterbar from Dashboard

Posted By Leif Glaes Wed January 27, 2021 09:49 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Removing filterbar from Dashboard

Posted By Leif Glaes Wed January 27, 2021 09:49 AM
Found In Egroup: Cognos Analytics \ view thread
Hi! Today, when a user open a Dashboard via a link, the filterbar/meny is always present (see attachment) and I want to automatic hide this to make more room for the actual Dashbord-data (so that the users don´t have to klick the filterlink manualy to hide it). Is it possible to automatic hide the ...

RE: Adding baseline to a linechart visualization

Posted By Leif Glaes Tue November 24, 2020 04:28 PM
Found In Egroup: Cognos Analytics \ view thread
Thank´s Henk! ------------------------------ Leif Glaes ------------------------------

Adding baseline to a linechart visualization

Posted By Leif Glaes Fri November 20, 2020 02:07 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! I have got a dashboard with a linechart visualization to which I want to add a horisontal baseline in form of a constant medianvalue (the value is not avalible in the datasource, it´s the median from another year). I can not add any new colums in the database to fix this. Is this possible? How ...

Problem gettings values to a dashboard

Posted By Leif Glaes Sat November 14, 2020 04:21 PM
Found In Egroup: Cognos Analytics \ view thread
Hi! Using Cognos 11.6 and have a dashboard in which i retrive data from a surgical datasource. I´m using the visualization called "Sammanfattning" in Swedish (see picture below) I have two values in the surgical report, one is the "Planned startingtime" for the surgical procedure and the other ...

Dashboard visualization

Posted By Leif Glaes Mon August 31, 2020 09:05 AM
Found In Egroup: IBM Business Analytics \ view thread
Hi! I have a datasource containing performed number of operations in a hospital and i want to have a dashboard visualization (line chart) with one line showing numbers of performed operations this year and thr another line showing last years result. How do I go about to achive this ? Be gentle - ...