Dear Community,
I have the following questin:
I have created a chart that. The values for it are calculated within a 30 virtual columns.
Currently if there calculated value is not a figure (for example โโโ, or blank โโ) the value of each data is shown/set to โ0โ.
But i would rather have just a blank instead, like here. Unfortunatelly it seems like it just works with physical (real) columns, not virtual ones.
I have tried with decimal("") or just โโ or " " to reach the same result within the chart that gets its data out of the virtual columns but it didnโt work. (Unfortunatelly it seems like working with โshow ifโ doesnโt work too, as in my case there are also more than one set of data within a chart.)
Appreciate help
If virtual and physical columns are handled differently, Iโd call that a bug. Please contact support@appsheet.com for help with this.
Thank you fo reporting this.
@Arthur_Rallu @benhare letโs look at this as we are touching this codeโฆ Itโs weird that we are handling physical and virtual column differently. I think we need a proper option for handling null values, meaning treating it as a 0 or as a missing value and thus a line chart should join the two existing point and ignore the null position entirely. But that should be an option as Null may have different meaning semantically with different columns (Null as measure vs Null for a dimension type column)
What I have recognized is, it may also depend on the formula of the column (maybe it is just not able to calculate sereval if-loops). If I just type โโโ into the column formula it appears correct. But not with an bit of expression inside, like (shown value (absolute or relative) should depend the user button choice):
*IFS(
AND(
[Chart_Button_FILTER_01] = โ1 Mโ,
[Chart_Button_FILTER_02] = โAbsoluteโ
),
[Value_01] / 100,
AND(
[Chart_Button_FILTER_01] = โ1 Mโ,
[Chart_Button_FILTER_02] = โRelativeโ
),
( [Value_01] - [Value_30] ) / [Value_30]
)*
Hey TDhers,
have there been any updates on that?
Cheers
I have the same problem, any solution?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |