Tooltip Date Format for a Line Chart

[barrp]

Hi everyone,

I have a simple line chart with date as the dimension and price (index value) as the measure.  In the tooltip however, the date is appearing as a number.  Anyone know how to format this as a date?

Thanks

[sandeep-singh · Accepted solution]

You can convert you dimension to date format in the load script like " Date(your Dimension,'MM/DD/YYYY') " or any date format you want to display.

You can do it on the front-end as well, but it will treated as a  calculated dimension. As a practice, we should avoid creating calculated dimension.

[barrp]

Thanks very much.  I specified the date format in the Data Manager but it requires your formula to format correctly in my charts.