Hello everyon
Is there a way to display only the final value of the metadata on the x-axis?
On my ticket metadata, I have "Cancel Trial" nested under Workflow and I was wondering, is there a way for me to display only "Cancel Trial" on the x-axis of the report?
Currently, its showing the whole nest and gets truncated.
Is there a better way to do it? Open to feedback!
Hey @nick11, it looks like 'Workflow::Subscription::Cancel trial' might be a nested custom field. There is a great article here that walks you through how to isolate the different levels of a nested dropdown field into their own attributes. You would then add the attribute for your third level to the column.
Hi @christopher15
Thank you for the suggestion, I've tried it, and works perfectly. But I have a problem with the visualization, when I add this report to my dashboard, the result gets truncated and forces me to scroll for the rest of the results, is there a way I can set it to fit to screen instead of scrolling?
Glad I could help Nick. You should be able to adjust the width on the report so that there's no horizontal scroll. If the default dashboard size isn't wide enough you can make it bigger by going to the 'Dashboard' tab and selecting 'Dashboard width':
Hey @christopher15 I tried as per your suggestion but I don't think that solves the issue.
If you look at the screenshot below. You can see I've extended the report width but it somehow still gets truncated.
Do I have to alter something within the report itself?
Hey Nick. What do you mean by 'truncated'? I can't see a scroll bar anymore. What are you expecting to see that you can't see?
This is what I get atm. I've extended the width but somehow the report sticks to a certain ratio..
I tried checking and unchecking the fit-to-screen option under the report settings but doesn't seem to be like changing much.
Any ideas?
I'm really not sure on this one. Is it that you're missing values in 'List level one' and 'List level two'?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
How the table is displayed on the dashboard should be similar to how the report looks like at the report level. Adjusting the size of the widget or the tab won't automatically change the size of the actual table/report. Usually, the column width adjusts based on the values inside the cells. But you can manually set the width of the columns via the Chart configuration menu (on the actual report). See Setting column width.