Charts Plotting 0
Comments
-
@Josh Reed When copy/pasting, you have to ensure that your ranges and columns are named exactly as the formula you are pasting in. I copy/paste quite frequently, so I couldn't say for sure what issue you may have run into.
-
@Paul Newcome Interesting, maybe I misplaced a comma or something instead. I literally copy/pasted the entire formula as I am creating a simple bar chart displaying count of contracts per month for a given category, and I'd like to display numbers, unless they are 0.
=IF(COUNTIFS({TA-Tracker}, "Immunology & Inflammation", {Event Date-Tracker}, >=DATE(2022, 4, 1), {Event Date-Tracker}, <=DATE(2022, 4, 30)) > 0, COUNTIFS({TA-Tracker}, "Immunology & Inflammation", {Event Date-Tracker}, >=DATE(2022, 4, 1), {Event Date-Tracker}, <=DATE(2022, 4, 30)), " ")
Nothing crazy, when I typed it out manually, no problem. I must have made an error or something on the first attempt.
Thanks again!
-
Hi Paul, I really need help in adjusting my formula to not show Zero on dashboard graph. I want to show all data on graph and it has a lot of zero as well but I want only greater than zero to be displayed on the graph
My formula is =COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$47, {IAT Data Analysis Range 1}, $[Primary Column]$48, {IAT Data Analysis Range 2}, [Column2]$48, {IAT Data Analysis Range 4}, $[Primary Column]49)
-
@Sarita Sah You would need to adjust your formula to say that IF it is greater than zero then output the result.
=IF(COUNTIFS(......)>0, COUNTIFS(.....))
-
This is giving error UNPARSEABLE.
=COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$11, {IAT Data Analysis Range 1}, $[Primary Column]$12, {IAT Data Analysis Range 4}, $[Primary Column]@row, {IAT Data Analysis Range 2}, [Column2]$12, {IAT Data Analysis Range 8}, <=$[Column2]$11),>0,COUNTIFS({IAT Data Analysis Range 3}, $[Primary Column]$11, {IAT Data Analysis Range 1}, $[Primary Column]$12, {IAT Data Analysis Range 4}, $[Primary Column]@row, {IAT Data Analysis Range 2}, [Column2]$12, {IAT Data Analysis Range 8}, <=$[Column2]$11)
-
@Sarita Sah You forgot the IF at the very beginning.
