Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am having trouble coming up with the solution or if its even possible.
I have a client that runs multiple questions per location and as long as one is answered that store is marked complete.
The store can have up to 20 questions. The other detail is that the 1st question is the important one. So if question 1 and 2 are answered we want to Display question 1, but if question 3 and 4 are answered, we want to display the one that was answered first.
How can I do that?
Solved! Go to Solution.
pls see the attachment below
Proud to be a Super User!
Here is the data and the desired output. Hope this helps.
Store | Question | Answer | Complete/Not Complete |
1 | New Release | Yes | Complete |
1 | Promotion | No | |
1 | Support | No | |
2 | New Release | Yes | Complete |
2 | Promotion | "Blank" | |
2 | Support | "Blank" | |
2 | Distribution | "Blank" | |
3 | New Release | "Blank" | Complete |
3 | Promotion | "Blank" | |
3 | Support | Yes | |
3 | Distribution | "Blank" | |
3 | Remodel | "Blank" | |
4 | New Release | "Blank" | Complete |
4 | Promotion | "Blank" | |
4 | Support | "Blank" | |
4 | Distribution | Yes | |
4 | Remodel | "Blank" | |
5 | New Release | "Blank" | Complete |
5 | Promotion | "Blank" | |
5 | Support | "Blank" | |
5 | Distribution | "Blank" | |
5 | Remodel | Yes | |
6 | New Release | Yes | Complete |
6 | Promotion | Yes | |
6 | Support | "Blank" | |
6 | Distribution | "Blank" | |
7 | New Release | "Blank" | Not Complete |
7 | Promotion | "Blank" | |
7 | Support | "Blank" | |
7 | Distribution | "Blank" | |
8 | New Release | "Blank" | Complete |
8 | Promotion | Yes | |
8 | Support | Yes | |
9 | New Release | "Blank" | Not Complete |
9 | Promotion | "Blank" | |
9 | Support | "Blank" | |
9 | Distribution | "Blank" | |
10 | New Release | "Blank" | Not Complete |
10 | Promotion | "Blank" | |
10 | Support | "Blank" |
pls see the attachment below
Proud to be a Super User!
could you pls paste the data here (not the screenshot)?
and what's the expected output based on the sample data you provided?
Proud to be a Super User!
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |