Get Free Trial
Get Free Trial

How to show whole date value in the one column or row in pivot?

Kranthi asked on September 10, 2019

I have a date filed in my JSON data source. But in the FM pivot it is spited to Year, day, Month. 
But I want to show whole date complete date in date format in columns or rows. 
How to do that?

3 answers

Public
Kranthi September 10, 2019

Please find the attachment for reference. I want to drag the full SystemEntry date to rows. Customer wants to see the Date column not the year, month, day as separate columns or rows.  

Attachments:
DateFormat.PNG

Public
Vera Didenko Flexmonster September 10, 2019

Hello, Kranthi,
 
Thank you for your question.
 
Here are two ways you can achieve the desired output:
 
1. By specifying the needed date data type in the JSON meta-object.
    For your case, we kindly suggest using the date string date data type.
    Please see our data types in JSON guide for more details.
 
2. By specifying the defaultDateType parameter in the options object:
    The defaultDateType parameter is used to specify which data types should be applied to date fields by default (date, date string, year/month/day, year/quarter/month/day or datetime) for CSV and JSON data sources.
 
Please let us know if this works and if you have further questions.
 
Best Regards,
Vera

Public
Kranthi September 11, 2019

Hi Vera,
This worked.
Thank you!

Please login or Register to Submit Answer