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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I am trying to force add Jan and Feb to the month field. For example, Group XYZ only has data for the month of March, but I need to show 0's for Jan and Feb. or if a group has data for Jan and Feb but nothing in March, I will need to march in but show 0's. How do I accomplish this? Also, I want to be able to scale it to any other group that may show up in Apr but has no values in Jan, Feb or Mar.
I've constructed the attached workflow that shows how you might go about creating a check to make sure that the correct number of months is included. This workflow uses your exact text to make sure that Feb, Jan, and Mar are all present for each group. If you wanted to scale up and add April (or subsequent months), you can simply alter the filter to 4 months and add April in the text input. I hope this helps!
I have another question related to this post: Once I added the month field, how would I populate the Group ID and Group Category? I tried using the Multi-row formula with an If then statement, but that did not work. Thanks!
I would create a key in the form of a text input that has each group name and its corresponding group ID and group category. I would then join that key data in at the end of this workflow to make sure that these fields are joined in for each group name (join on group name). You can also use a formula tool to write an if then statement for the group ID and group category fields, separately.