Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakkrish
Creator
Creator

Calculate Avg of Month Timestamp

 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

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi in your dimension use this expression 

=monthstart(TimeStampfield)

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

deepakkrish
Creator
Creator
Author

It gives first day of the month . Not working.

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.