Giovanni Norero Posted May 16, 2019 Share Posted May 16, 2019 Hello, Looking for an option to show 0 values on the line chart average without 0 values (just week days) and average with 0 values (closed days but would like to include on calculation) linechart over time (days X-axis) the number of items by category (daily sum y-axis) are there any setting that: will drop the marker to days with 0 will allow to calculate average based on days with values and all days past the automated output report comes in *.csv and skips days with 0 and only outputs days that have values, therefore it skips holidays or any days closed. thanks! Hello Gaia, Basically, as per the picture attached at the moment the line does not drop for 0 days also the avg is vased on the values and it does not take into account the days at 0 I would like the line to show 0 for April 30 to May 7 also the avg in that case should be 1770 when accounting for 0 days. regards Giovanni Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 17, 2019 Share Posted May 17, 2019 Can you please clarify your question and upload examples Link to comment Share on other sites More sharing options...
Giovanni Norero Posted May 17, 2019 Author Share Posted May 17, 2019 Hello Gaia, Basically, as per the picture attached at the moment the line does not drop for 0 days also the avg is vased on the values and it does not take into account the days at 0 I would like the line to show 0 for April 30 to May 7 also the avg in that case should be 1770 when accounting for 0 days. regards Giovanni Link to comment Share on other sites More sharing options...
Giovanni Norero Posted May 20, 2019 Author Share Posted May 20, 2019 Hello Gaia, I did, see above, thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now