Hi!
A question - can I suppress zeroes when I'm using a Column chart?
I saw that option in Waterfall.. but I guess it is the only one where I can do it?
And no options about handling Zeroes in other types of charts?
Thank you.
Hello @JoannaAn
Can you show us an xample?
Have you tried setting to zero format to Blank?
Another option is to set a filter to hide items with value 0 from the chart
@JoannaAn
You can try using an IF THEN ELSE statement in you data to return DIVIDE(0,0) if the data is a zero this will return a NA for all zeros which will not show on the final chart.
If you need to display this data in a grid on a page create a duplicate module and use this IF THEN ELSE and use this duplicate grid to feed your chart.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
