Hi everyone,
I am new to Tessitura Analytics and I am currently having issues with the progress to goal widget indicator. I am trying to use the gauge design to show a visual of the percentage up to date.
My value formula and secondary formula are currently the same: SUM([Total Amount]/sum([Campaign ID],[Max Campaign Goal Amount])).
Because of this, the widget indicator shows 0.33 and not the percent. I know that I can change the actual number through the format function. I am having trouble being able to change the actual widget indicator to show 33% and not .33. Is there anyone that can help assist with this?
Thank you so much!