-
15. Re: Uniform axis range not working as expected
juliette.mccormack Dec 4, 2013 8:14 AM (in response to Ville Tyrväinen)Thank you Ville and Matthew.
This is very similar to Joe's post I referred to in my original question. However, if I use this method, how do I now distinguish between the males and females as I have ethnicity as my colour.
Is there anyway to label the positive and negative sides of the axis?
-
16. Re: Re: Uniform axis range not working as expected
Matt LuttonDec 4, 2013 8:20 AM (in response to juliette.mccormack)
1 of 1 people found this helpfulHere's one option for coloring--you can drag multiple fields to the color shelf by holding the SHIFT key. This creates a unique color for each combination of gender/ethnicity, but it may work in this instance.
As far as labeling each side of the axis, this cannot be accomplished by editing the axis since its really only one axis now. You could work around this by placing text boxes below each side of the axis, and positioning things carefully within dashboard containers so it all lines up nicely.
Hope this has helped. See attached for coloring I set up--there may be other ways to accomplish a better color scheme.
-
17. Re: Re: Re: Uniform axis range not working as expected
juliette.mccormack Dec 5, 2013 6:38 AM (in response to Matt Lutton)I didn't remember you could do that. I also tried the attached which was to background shade the male side blue and female side pink and label each side using reference lines. It doesn't look v crisp and clean though so not the ideal solution.
This method raises the other issue of getting rid of negatives on left hand side of axis. Have you looked at the thread I posted in original request which has a solution provided by Joe Mako He suggested formatting the calculated field with the negative value (which I tried on Countd Male) with 0;0 which I have tried but doesn't seem to work in this instance. Any ideas?
Sorry to take up so much of your time!
BW
J
-
18. Re: Re: Re: Re: Uniform axis range not working as expected
Matt LuttonDec 5, 2013 6:46 AM (in response to juliette.mccormack)
Yes, I believe that was for labeling the marks like in the attached--the marks show as positive numbers with that custom format.
-
19. Re: Uniform axis range not working as expected
juliette.mccormack Dec 5, 2013 7:01 AM (in response to Matt Lutton)But he also achieves positive values on both sides of his axis.
-
20. Re: Uniform axis range not working as expected
Matt LuttonDec 5, 2013 7:08 AM (in response to juliette.mccormack)
Yes, well, the setup he uses is different from this one, too. He has one calculation that determines male or female, and gives a value of 1 or -1, based on whether they're male or female. You'd have to set up your view the same way to use the same techniques he used.
-
21. Re: Uniform axis range not working as expected
juliette.mccormack Dec 5, 2013 7:10 AM (in response to Matt Lutton)OK, will re-work. Many thanks for your time Matthew.
Juliette
-
22. Re: Re: Uniform axis range not working as expected
Michel Caissie Dec 5, 2013 8:08 AM (in response to juliette.mccormack)If i can jump in and propose a solution to the original question;
- You can bring a negative copy of the female count on the column shelf at the right of the Male Count.
- Set the color transparency at 0%
- Make it dual-axis with the Male Count and synchronise Axis.
Michel
-
23. Re: Uniform axis range not working as expected
Shawn Wallwork Dec 5, 2013 9:04 AM (in response to Michel Caissie)1 of 1 people found this helpfulYou can also do it with invisible reference lines on each axis, with this calc:
IF COUNTD([Person Female] )>COUNTD([Person Male] ) THEN COUNTD([Person Female] )
ELSE COUNTD([Person Male] ) END
(See attached)
--Shawn
-
24. Re: Uniform axis range not working as expected
Matt LuttonDec 5, 2013 9:11 AM (in response to juliette.mccormack)
Nice solutions by both of you--thanks for sharing!
-
25. Re: Uniform axis range not working as expected
juliette.mccormack Dec 6, 2013 1:44 AM (in response to juliette.mccormack)Michel and Shawn
Thanks very much to both of you for jumping in. I have learnt quite a few new things from this thread so thanks to all of you.
I'm afraid although both correct answers, it's been assigned to Michel as he posted first but all responses have been appreciated.
Best wishes
Juliette