If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Formatting data in Dashboard

Started by DEL2026, 15 Feb 2018 11:51:33 AM

Previous topic - Next topic

DEL2026

Is it possible to change the format of data in the dashboard?  i.e., number is coming in and I want to format it to include $ and decimal places.  If dates are coming in as December 31, 2017, is there a way to change the format to 12/17 ?
Thanks indvance,
DEL

Pratap Reddy

#1
Hi,

Drop a date on Dashboard and expand the Date.Go to Level one of Date Column and click on the right of Date, it will show the options Filter,Sort,Top or Bottom,Format and Remove column. but you may not find that much of functionality options in dashboard as Active Reports or Reports.

Thanks,
Pratap

DEL2026

Thank you Pratap.  I was afraid that was the answer, but wanted to check just in case.   :)

hardstep

Sadly not enough formatting options IMHO !.
It would be great if you could !.

Pratap Reddy

Quote from: DEL2026 on 16 Feb 2018 06:43:13 AM
Thank you Pratap.  I was afraid that was the answer, but wanted to check just in case.   :)

You can use this as a calculated field for the above format.if your fixed to the above format.here is the expression for 12/17

to_char(cast( [Sales (query)].[Time].[Date] , date),'MM/YY')

Thanks,
Pratap