I have a client that would like a widget on their dashboard the lists the top 5 clients by revenue. Compiling the data is one thing, but I don't even think there is a chart/list that would even limit to the top 5, correct? Has anyone else run into this kind of issue in the past? I find clients that are migrating from Salesforce find out dashboards very outdated looking.
The list gadget have a property that will only display '5' or whatever rows you want at a time.
But we create our own gadgets to be as sophisticated as we need.
The number of rows set to 5 should be good enough...Any idea why i cant sort on a new field number/currency field I created in company? The sort options are grayed on the widget.
Ah... You can only sort on strings.
The Filter by field returns data containing the text entered. You can filter by any string (character) type of field, which is displayed on the gadget. You cannot filter by numeric or date/time fields.
Then how would I do a top sales customer widget (mind you think needs to by assign to user). If i make that a text field the sort is basing it on the first digit in the number, as per below. Not to mention, even still I can't sort the widget itself, just the report.
Thank you for all your help thus far!