How do I show the date field as MM/dd/yyyy in flexmonster pivot table? I keep getting the FLIGHT_DATE to show as a date hierarchy (FLIGHT_DATE.Day, FLIGHT_DATE.Month, FLIGHT_DATE.Year).
Here's a line in my JSON data for FLIGHT_DATE: {[FLIGHT_DATE, 02/03/2016]}
var reportQ3 = {
dataSourceType: "json",
data: jsonData2,
rows: [{
uniqueName: "POS_LEVEL5_CD",
hierarchy: "Geography",
type: "level",
parent: "Airline",
caption: "Continent"
}, {
uniqueName: "POS_LEVEL4_CD",
hierarchy: "Geography",
type: "level",
parent: "Continent",
caption: "Country"
}],
columns: [
{ uniqueName: "OPERATING_AIRLINE", caption: "Airline", type: "string", active: true },
{ uniqueName: "FLIGHT_DATE", caption: "Flight Date", type: "string", active: true },
{ uniqueName: "[Measures]", active: true }
]
}
Hello Mike,
Thank you for the question.
You can use "date string" type for such hierarchy, please check the following JSFiddle - https://jsfiddle.net/iansadovy/kvttpgLw/
Please let me know if it works for you.
Regards,
Ian
Hello Mike and all Flexmonster users,
After the release of version 2.3, we would like to provide you with the updated sample: https://jsfiddle.net/flexmonster/uv1qop22/.
Regards,
Tanya