I am trying to create multiple columns with True/False values displayed by shapes, a check mark for true and an x for false. I was able to add one of the true/false columns as you can see in the attachment; however, when I tried to bring in a second column, the marks box keeps assigning it to color and won't allow it to be a shape.
Is there a workaround for this situation? I have been unable to come up with a solution.
Thanks!
Phil
Jan 29, 2019 3:46 PM
Hi, Phil
You can try the place holder a measure e.g. min(1) in the columns, add multiple of them for each of your measures.
If you can provide a sample workbook, it will be easier to show step by step
ZZ
Jan 29, 2019 10:21 PM
thanks for the workbook, Phil
Please find my solution attached.
Below is the screenshot of result
Hope this helps
ZZ
Zhouyi,
Thanks for the reply. I think this should work, but when I tried to implement the solution in my production workbook, it still is not allowing me to get to the multiple fields. It keeps changing the new T/F category to another type of mark, usually color, and if I try to change from color to shape, it replaces the old T/F category that had been in shape with the new T/F category. That seems to be the obstacle now.
Thanks!
Phil
Jan 30, 2019 4:20 PM
Hi, Phil
Can you provide your sample workbook or at least some screenshots to help me understand where you stuck?
ZZ
Zhouyi,
I did figure it out. Thanks for sending. I did have one more quick question on the workbook, which I have attached to this reply. For the spend above control variable, i created a variable that takes the difference in % between the promo group's spend and the control group's spend. In the first row, it gives me an answer, but on subsequent campaigns, it compares the control group to the promo group of the previous campaign. These comparison %'s are meaningless. For example, the 76% on the January Promo Group line makes sense, but -212.5% and -300% for the February and March Control group line are meaningless, because they are comparing control and promo for two different months. Is there a way I can hide the Spend over Control % for the control group line but keep them for the promo group?
Thanks so much for all your help on this workbook. It has been instrumental in finishing this project.
Phil
Jan 31, 2019 7:53 PM
Hi, Phil
Hope I understand your requirement, please refer to below screenshot and if it what you expected, please find the workbook attached. and if it is not, please let me know what have missed.
ZZ
Feb 1, 2019 3:11 PM
No worries, Phil, I am glad to help.
If my answer solve your question, can you mark my answer as correct to close the thread? thx
ZZ
