Calculate Avg of Month Timestamp

[deepakkrish]

 Hi All,

I have a date field as Timestamp and it shows the Monday date only . I am showing some trends by week like below. 

01/06/2020 - 70%

08/06/2020 - 40%

15/06/2020 - 70%

22/06/2020 - 80%

28/06/2020 - 70%

My requirement is, I have to show Average  percentage by month(Using those timestamp dates) . Please suggest ideas to implement this.

Regards,

Deep

[lironbaram]

hi in your dimension use this expression 

=monthstart(TimeStampfield)

and the expression should be the same as you use in your current display  

[deepakkrish]

It gives first day of the month . Not working.

[Brett_Bleess]

Best I can offer is the following specific Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

If you want to search further in that area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett