Category
Chart Builder
Product Version
9.0
Ability to dynamically switch dimensions on reports
Idea Logged
Hi Team,
We should have the ability to dynamically switch dimensions on reports, without limiting the drill through functionalities. The idea is to have something similar to what is available in Tableau, where users can choose from a picklist of dimensions: https://vizyul.com/tableau-dynamic-dimensions/
Please let me know if there is any workaround currently available to achieve the same in Yellowfin and whether this is in the Product roadmap.
Kind Regards,
Asif Bhat
I like this idea 
Hi Asif,
We do have dynamic fields that you can add as text widgets to a report canvas. However, we don't have the capability out of the box to effectively switch between different charts with a dropdown menu. It's possible you could create something with a code mode dashboard after you've set up the charts for each dimension.
It's not in the product roadmap, as far as I know, but I can create an enhancement.
Kind regards,
Chris
Hi Asif,
We do have dynamic fields that you can add as text widgets to a report canvas. However, we don't have the capability out of the box to effectively switch between different charts with a dropdown menu. It's possible you could create something with a code mode dashboard after you've set up the charts for each dimension.
It's not in the product roadmap, as far as I know, but I can create an enhancement.
Kind regards,
Chris
Any documents around how we can create dynamic fields and also using code mode to achieve this functionality ?
Any documents around how we can create dynamic fields and also using code mode to achieve this functionality ?
Hi Asif,
We have an article on the Wiki for dynamic fields: https://wiki.yellowfinbi.com/display/yfcurrent/Text+Widget+Parameters
We do actually have a content example, created by Brett, that gives you pretty much the outcome you're looking for using drill dimensions:
Here you can select a data dimension and then it'll update the charts accordingly.
The link below includes create scripts for the data source and data (in Exasol), and a .yfx file for the view and reports. Hopefully that proves useful. If you want to use it in Exasol, they do offer a free Community version, but you might be able to convert the scripts to work with other databases.
https://ftp.yellowfin.bi/f/af5edd2cb17b05db
Kind regards,
Chris
Hi Asif,
We have an article on the Wiki for dynamic fields: https://wiki.yellowfinbi.com/display/yfcurrent/Text+Widget+Parameters
We do actually have a content example, created by Brett, that gives you pretty much the outcome you're looking for using drill dimensions:
Here you can select a data dimension and then it'll update the charts accordingly.
The link below includes create scripts for the data source and data (in Exasol), and a .yfx file for the view and reports. Hopefully that proves useful. If you want to use it in Exasol, they do offer a free Community version, but you might be able to convert the scripts to work with other databases.
https://ftp.yellowfin.bi/f/af5edd2cb17b05db
Kind regards,
Chris
Hi Asif,,
Quick follow up on this ticket, did the information I provided below help at all with your request?
Kind regards,
Chris
Hi Asif,,
Quick follow up on this ticket, did the information I provided below help at all with your request?
Kind regards,
Chris
Hi Chris, of course there are several workarounds possible to tackle this situation, but I think a simple and not too complex solution would be to extend the parameter functionality in Yellowfin with the ability to create a list of valid values.
Currently if you create a parameter with data type "text" the user has to manually type in a value. If it would be possible to create a list of valid values, preferably with the option to type it manually, use a certain dimension from the view or create a custom query (similar to filters) then you can use this parameter in a calculated field to determine which dimension (or metric) to display.
Hi Chris, of course there are several workarounds possible to tackle this situation, but I think a simple and not too complex solution would be to extend the parameter functionality in Yellowfin with the ability to create a list of valid values.
Currently if you create a parameter with data type "text" the user has to manually type in a value. If it would be possible to create a list of valid values, preferably with the option to type it manually, use a certain dimension from the view or create a custom query (similar to filters) then you can use this parameter in a calculated field to determine which dimension (or metric) to display.
Hi Jaromir,
Thanks for your input on this one. Always appreciated!
Hi Jaromir,
Thanks for your input on this one. Always appreciated!
Replies have been locked on this page!