Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pkseenu
Contributor
Contributor

Finding current month avg based on last three months average

Hi Friends,

 

I have last threes months average value for LTTR based on this values I would like to find the forecast of current month avg. 

 

pkseenu_0-1602584252954.png

 

=Avg({<[Flag]={"Resolved"},[PARENT]={"No"},[FYI-Cancelled]={"No"}>} [LTTR])

 

can someone pls help to find the forecast for this month?

2 Replies
sunny_talwar

@pkseenu where do you want to show this number? In a KPI or in a chart where you have MonthYear as a dimension?

pkseenu
Contributor
Contributor
Author

In a KPI