Ability to dynamically switch dimensions on reports

Asif Bhat shared this idea 5 months ago
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

Comments (6)

photo
1

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

photo
1

Any documents around how we can create dynamic fields and also using code mode to achieve this functionality ?

photo
1

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:

6%20Quick%20Reports%20Sub%20Tab%202

Here you can select a data dimension and then it'll update the charts accordingly.

7%20Quick%20Reports%20Sub%20Tab%203

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

photo
1

Hi Asif,,

Quick follow up on this ticket, did the information I provided below help at all with your request?

Kind regards,

Chris

photo
1

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.

photo
1

Hi Jaromir,

Thanks for your input on this one. Always appreciated!