on 01-04-2007 1:07 PM
Hi, I have a BI Query supplying data to a chart component. The Category Axis Values are Dates coming from the query. The dates are showing up as YYYYMMDD and not formatted in MM/DD/YYY like I would like them to be. I don't see anywhere that I am able to format them like I do with a Table View Component.
How can I format my dates coming directly from my BI Query into a Chart Component?
Thanks for any help!
Hi,
did you try the external key? Date fields in BI queries are user specified formatted in the external key (key_ext).
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kenneth,
you must change the format with a formula in VC. I'm not sure if you can use a formula in the chart settings. If not, you can you can show the values in a table first and then connect your chart with the table. In the table you can add a further column, which get the date from the other column, then you can do the formatting in this column and use these values in your chart.
Best Regards,
Marcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.