Article/more information about using derived columns?
Hi all! I am trying to create an approvals dashboard for our team that includes a bar graph showing the top five grants for the filtered period. In that graph, it would be helpful to see the project name beside the organization name on the y-axis of the bar graph.
I see the option to create a derived column at the bottom of the data set. Is there documentation somewhere that I can reference on using some of the different functions for derived columns? Specifically, I'm trying to see how to add a space when using concatenate. Thanks!
Comments
-
Hi @DevinCecere I think this should answer your question:
Otherwise, if not, reach out to our support team and they can help you troubleshoot!
0 -
@MariusDereskevicius, thank you for sharing that post. How did you add a space holder to the first example with the concatenate function? Adding a space in between the two items in my dashboard would be ideal. Thank you!
0 -
@DevinCecere it's actually two "concatenate" functions with a set of apostrophes in between. You can put any text you'd like within the two apostrophes, including a space.
So technically it's: {field1} || ' ' || {field2}
1
