Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Here is the context. I have several projects, associated to a current phase. Each phase belongs to one or two categories, Development or Clinical (Dev_Flag and Cli_Flag). I have this set of data :
Project | Phase | Dev_Flag | Cli_Flag |
---|---|---|---|
Prj_1 | Ph_1 | Y | N |
Prj_2 | Ph_2 | Y | Y |
Prj_3 | Ph_3 | N | Y |
Prj_4 | Ph_2 | Y | Y |
Prj_5 | Ph_1 | Y | N |
I would like to display on a bar chart, the repartition of my projects by Phase and type of Phase (Development or Clinical). So, I've made a calculated dimension to build my two categories :
=If (Dev_Flag = 'Y', 'Development', If (Cli_Flag = 'Y', 'Clinical'))
Problem is that "If" condition is exclusive. Ph_1 and Ph_2 belong to both categories but are displayed only in the first encountered category in "If" Statement. Look at the attached example.
How can I make related projects appear in both category ?
Thanks,
Julien
Hi! Try like this.
I belive ph_1 not included in Cli flag
if you see closely there is only N value for CLI flag
so Ph_1 will not appear in CLi category
Hi,
I think you need one more value i.e. Both. Meaning the Project Names which falls in both the category Development and Clinical.
Have a look at the example attached.
Regards,
Kaushik Solanki
Hi !
First of all, thanks for your answers.
Sunil, I'm sorry, I don't understand your note. Ph_1 is not included in Clinical bar because of the Cli_Flag value (equals to N). It's what I expect. Problem is about Ph_2 that is only displayed in Development bar despite Cli_Flag value equals to Y.
Kaushik, attached example is mine. You've probably sent the wrong file. By the way, I've add a both flag but problem remains the same. In "If" statement, if the first condition is checked, the second is ignored. A same value can't appear in both bar.
Regards,
Julien
Hi,
Sorry for wrong file.
Please have a look at the attached file.
Regards,
Kaushik Solanki
Hi! Try like this.
Very interesting tip KostinSergey, it works fine ! Thanks Kaushik for your answer but Kostin's one is exactly what I expected.
Thanks for your time everybody !
Regards,
Julien