Is it possible to hide the Legend and Popup fields which have empty values?
You could maybe apply a filter to your chart to only show values greater that 0.
That seems to just show or hide the chart if the filter is met.
That shouldn’t be the case. Did you add a filter, or a visibility condition?
If I apply the filter and the data is less than 0 it just hides the whole chart.
Can you show me a screen shot of your chart data?
The chart is showing the below data, filtered by a reference number.
There are multiple pricing records (rows) per reference number, the chart is to show the pricing history.
Currently it is displaying data points on the chart for empty fields.
If 1Kg is greater than 0…OR if 3KG is greater than 0… OR if 4KG is greater than 0…all of them
If your values that are 0 are empty cells you could check for ‘is not empty’ instead of greater than
Hmm, I though your data would have been structured differently. Now I see the problem that adding a filter is going to filter out the entire row. There is absolutely no way to filter out individual columns.
I’m actually not quite sure why your are trying to hide certain columns. I assume that each row in your data represents a date. Each day can have a column value that’s either populated or empty. You’re chart above is only showing 2 rows of data (two days). I can’t quite decipher which two rows they are, but looking at the screenshot of your data, let’s pretend that the chart is showing the last two rows of data. Almost every Kg column has at least one populated value and one empty value between those last two rows. How would you expect that to display in the chart if everything with a zero or blank was excluded? Each item is going to have a point in each x axis date, so if a particular date had a value of zero, you would want to see that represented in the chart. Unless your goal is to hide a Kg item if all rows for that item have an empty value. In that case, it’s not possible because it’s assumed that since you chose to display that column in the chart, you want to see the values, even if they are zero.
Glide charts are pretty limited in how you can use them and set them up. Personally I’m not a big fan of how they work. You choose which columns to display in your chart, and even if they are zero, they are going to be included in the chart. The data is dynamic, but the configuration is static once you have it set up. Even if you could structure your data differently to be row based instead of column based, I don’t think that you would get the results you are expecting.
I think your best option would be to use an external chart, such as Quickchart. Your going to have a lot more design freedom and you only pass it the data you want to see, so if you know an item would be zeros across the board, you could simply not pass that item to quickchart and it would not display in the chart. It’s a bit more to set up initially, but it’s a lot more flexible in design.
Thanks Jeff,
Yes the charts are quite limited with the static configuration. Not a deal breaker, just makes the data a little harder for users to digest.
Hopefully some more functionality will come to charts in the future.