This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to create a report that shows chemical usage week by week. Most chemicals are used every week but some some aren't, for example, maybe used in week 5 and not used again until week 8. Unfortunately in my source data it doesn't say week 6 and 7 equals zero, there just is no mention of these weeks. I would like to create a row in Alteryx to fill a gap between 5 and 8 that just shows usage as zero. Any suggestions? thanks