Hello, on a board I have a label column to label projects as Rush. In order to have a rush percentage out of the total number of projects, I have created a formula that says: concatenate(({Rush#Count})*100).
This formula allows me to have a Number widget and display the % of Rush projects out of the total.
However, if I want a chart widget, the labels on the chart say 0 and 100 as they are indeed in the formula. Is there a trick to the formula that allows me to convert “100” to “Rush” and “0” to “Regular”?