Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
elizabeth__
Contributor III
Contributor III

Display change in percentage week-by-week in heatmap

I have the following calculations that give me a scrap %

calc.PNG

 

And this heatmap shows that value over Date.autoCalendar.WeekYear by Platform

heatmap.PNG

 

I have received a request to change this instead to show the difference between the percentages on a weekly basis. 

So for example, if last week our scrap % for a platform was 3.0% and this week it is 3.5%, the heatmap would display + 0.5% for the current week to show an increase. So 2019-44 in this case would show + 2.7%. I can't figure out how to calculate the change based on the previous week.

0 Replies