1 of 1 people found this helpful
The secret is probably to use a "table calculation function" such as WINDOW_SUM:
IF WINDOW_SUM(SUM([Number of Records])) >= [Minimum Number of Records] THEN 1 ELSE 0 END
That looks pretty useful, but it isn't quite what I'm looking for. I specifically want to be able to replace the values under [Minimum Number of Records] with an a placeholder like "-" or "*" to indicate that there are values there, but that they are not shown as opposed to a null, which could either be no value or some values.
Thanks for your help!
Any chance you could share a packaged workbook with dummy data and a view that looks as close as possible to what you want to achieve?
This makes it much easier to help. Currently I am not sure I understand what you want to achieve, e.g. if the end result should be seen in a text table rather than a chart.
Here you are. My goal is to gain the benefits of the number formatting while also gaining the benefit of having the * in the text table. The end result for this purpose will be a a text table. '
MixedDataTypes.twbx 106.0 KB
Thanks. This is very easy to understand. I am glad to say that it is possible to add another field with an asterisk which only has values when the other doesn't and thus only one field visible.
This is something I learned from a comment by Jonathan Drummey.
See more details in attached workbook (and screenshot).
Jóhan a.k.a. Kettan
Seems like as close as I'll get. Thanks!