-
Graph is only showing 11 months of data for 12 months
Hi, I would like to show 12 months of data but because there is not data in December 2023 the month is not showing. I have selected Fill missing spaces which only works if I select for e.g. Nov 2023 then Dec 2023 column appears. How do I fix?
-
Multiple line chart and data labels
Hi in a multiple line chart is it possible to have one line with data labels and the other without any data labels?
-
Date range selector
Hi, How do I change the min and max value date format ie. 01/21/19 to 21/01/19
-
Target line
Hi I would like to show a target line for fy 24 (April 2023 to March 2024) and then start a new line starting for fy 25 (April 2024 then onwards) Can I use one target line which moves from target - 20 up until March 2024 the target 11 - from April 2024 onwards.
-
Duplicate a card
Hi I would like to duplicate a card and not have it linked to the original. How do I do this.
-
Display a zero value
How do I display a zero value for a location which has no data. I have 7 locations with only 6 displaying because the 7th location has no data. How do I get the location to display in the table an show a 0% value?
-
Highlighting data x location which does not meet a specified target
Hi, I have created a pivot table with a formula 'Weekly Target Flag' which highlights locations which have not met their weekly target of safety Observations. The problem is to get the data to highlight I need to add the formula as a column. The information then appears in the table. How do I create a formula which does…
