-
1. Re: Line chart with overlapped colored circles
Chris McClellanAug 16, 2017 3:36 PM (in response to Isaac Briseno)
I converted the Line Type to a number (logic in [Line Type Number]) then used some min/max logic to figure out what the proper colour was:
Let me know if you have any questions
-
LineChartWithColors CM.twbx 29.5 KB
-
-
2. Re: Line chart with overlapped colored circles
AB CommendatoreAug 16, 2017 4:14 PM (in response to Isaac Briseno)
Hey Isaac,
Sure can! With a dual axis chart you can add the circles. I've attached a revised version of the workbook you provided with instructions. That'll get you half way there - to a view with the line and the dots colored by transaction type. But a different dot will display for each account transaction each day.
To get the color to roll up the way you show in your screenshot, instead of individually for each transaction by account...I think you might need an LOD calculation, which is regretfully not one of my strong suits. Maybe another Community member can assist for the win here?
-
LineChartWithColors_revised.twbx 17.7 KB
-
-
3. Re: Line chart with overlapped colored circles
Isaac Briseno Aug 17, 2017 8:53 AM (in response to Chris McClellan)Thanks a lot Chris!
That's exactly what I was looking for
@AB Commendatore, you can check CM solution in case you want to see how he solved it, it worked great for me
Regards,
Isaac