topic Re: Parse Timestamp in Dashboards & Analytics Discussions

Parse Timestamp

KHK — Mon, 04 Sep 2023 11:47:04 GMT

Hi,

could you please let me know how to convert string to date of "4/1/2022 3:48:00 PM".

Re: Parse Timestamp

JoeM — Tue, 05 Sep 2023 13:19:43 GMT

@KHK - what is the current format of your string?

Re: Parse Timestamp

KHK — Tue, 05 Sep 2023 13:23:35 GMT

@JoeM Below is my sample data in String data type.

Re: Parse Timestamp

KHK — Wed, 06 Sep 2023 13:58:48 GMT

Can any one help on this?

Re: Parse Timestamp

anurag — Wed, 06 Sep 2023 15:01:47 GMT

@KHK can you try this:

date(

parseTimestamp(

left(

<time_stamp_column>,

"MMM dd, yyyy"

)

Re: Parse Timestamp

Shashidhar — Wed, 06 Sep 2023 15:08:47 GMT

Hi,

Do you need it in same format? including time?

Re: Parse Timestamp

KHK — Wed, 06 Sep 2023 15:57:39 GMT

@anurag ,Formula working fine for one year, i want to show two years month wise data on graphs, could you please let me know how to do?

Re: Parse Timestamp

KHK — Wed, 06 Sep 2023 16:02:26 GMT

@Shashidhar , i want to covert the above string Timestamp to date like 2023 January

Re: Parse Timestamp

anurag — Wed, 06 Sep 2023 16:04:37 GMT

@KHK please share more detail.

- How do you want to display data? What insight are you using? What dimension and measure are you using?

Re: Parse Timestamp

KHK — Wed, 06 Sep 2023 16:08:22 GMT

@anurag below is sample data.

Re: Parse Timestamp

KHK — Wed, 06 Sep 2023 16:25:38 GMT

@anurag, i am calculating count of PO's for each month.

Re: Parse Timestamp

KHK — Thu, 07 Sep 2023 16:34:51 GMT

@anurag Any update?

Re: Parse Timestamp

anurag — Thu, 07 Sep 2023 17:03:28 GMT

@KHK you need to join date column in the driving table to date dimension.

Use month column from date dimension and sort it by month_sequence to show months in correct order.

You can also use dual X axis insight to show count by year and month.