Trying to get my dashboard interface to show a graph with multiple Y axis that links to a record picker. So far, I've only been able to get 1 Y axis, I can get multiple Y axis when I don't use a record picker though.
multi-series chart and dual y-axes with record picker
+4
+15Hmm, you are correct that it doesn't appear you are able to have multiple axes when using a record picker. If having multiple axes is important to you, I suggest using the "dashboard" interface layout and utilizing dropdown filter options to allow the user to select the corresponding timeframe they need. It looks like from your screenshots that you have a desire to allow people to select the month and year. You can achieve this by creating a formula > single select output field for date with the formula:
DATETIME_FORMAT({date field name}, 'MMMM') & " " & DATETIME_FORMAT({date field name}, 'YYYY').
This will allow you to create the dropdown filter in the dashboard view to accomplish virtually the same thing, with the multiple axes. Hope this helps!
This will allow you to create the dropdown filter in the dashboard view to accomplish virtually the same thing, with the multiple axes. Hope this helps!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.