Is there any way where we create a day for an year?

Q&A
, , , , ,
1

I want to create a calculated field like if I used that calculated field then it need to give me a date for an year. I will use that day to display the data.

Is that possible?

2

Hi @hripraa - Can you please give an example for your requirement so that we can guide you the right solution approach.

Regards - Sanjeeb

3

@Sanjeeb2022 I have created 2 table, one is based on create date, and other one created on resolved date. Due to this i can’t able to combine both table into one because both table created with different dates. So I want to combine them.
Table 1

Capture
Capture1919×836 146 KB

Table 2

Capture1
Capture11911×835 154 KB

4

hi @hripraa

thank you for showing the example of the two tables. would you be able to show what outcome you are you expecting as well?

5

Hi @Wakana

Whenever i used my “Amazon week” calculated field in table which is showing correct week as marked in image but my wow% get disappear. I don’t know why the wow% disappear whenever i used " Amazon week" calculated field.

Amazon week formula: concat("Week ",toString( dateDiff(truncDate(“WK”, truncDate(“YYYY”, CreateDate)), CreateDate, “WK”)+1))

Wow% formula: periodOverPeriodPercentDifference(count(IssueUrl),CreateDate,WEEK,1)

Kindly help me on this

Capture
Capture1905×834 138 KB

6

Hi @hripraa,
Since you converted your date field to a string, it is no longer referenceable in the period over period calculation. It requires a ‘date type’ to run so that’s why you are not receiving any values. In order to make this work, you’ll have to reference the original date field by week or try using table calculations since you are on a pivot table.

I’ll mark this as the solution, but please let me know if you have further questions.

Thank you!