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.
We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
Need help urgently, Wanted to create a Dashboard 1 and 2 below. I know how to create 1... Please guide me how to create a Dashboard 2. Hereby shared sample data.
Received 3 type of instructions every day. Say A, B & C.
Some days only A instruction came, B & C are NULL
Some days only B instruction came, A & C are NULL
Some days only C instruction came, A & B are NULL
Some days A & B instruction came, C is NULL
Some days A & C instruction came, B is NULL and so on…..
But, I need to create the dashboard for A, B & C as final result. Wherever the instruction not came, those Variable marked as ‘0’.
Go to Solution.
Go to Solution.
A potential solution attached using a join to find missing data and then a union to add back in missing data (e.g. a right outer join)
Thank you @Joe_Lipski for the solution... To make 1 more step in it.
Now, I have below set data... How to create this...
You will need to use the Cross-Tab tool in this scenario.
Update attached and you can vote on the idea here of allowing a count in a cross-tab tool with non numerical values as this would have removed the need for the formula: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Cross-Tab-Aggregate-Values-Using-Count-on-Te...
Thank you.. @Joe_Lipski