Several question regarding Yellowfin

Luca shared this question 5 months ago
Answered

Dynamic titles

Is it possible to include certain filters that are selected in the user prompt in the title in a dynamic manner? I have tried several ways of trying this, but so far I have not succeeded yet. I know this is possible in other BI tools like Tableau, but have not found this functionality in yellowfin yet.

Creating a grand total based on the data

My team is trying to create a P&L statement for specific departments and for the company. So far we have created one report and put the different departments as a tabbed section. However, the whole company is not contained in the data (it is basically the sum of all departments). Is it possible to create another tab for this and make sure it is the sum of all the values?

Filtering on certain rows in a table based on the value of the filter.

Ideally the P&L for the whole company should omit certain rows (otherwise we need to create two separate reports). Is it possible to do this in Yellowfin?

Comments (3)

photo
1

Hi Luca,


Thanks for your question.


Unfortunately, at this stage, Yellowfin has no inbuilt text-based Charting options. You would easily be able to use a third-party Javascript library such as D3JS, Chart.js, or HighChart to name a few to fill in that requirement.


There is an existing Idea post here that you can subscribe to, which will be updated when an Enhancement has been implemented in a future release of Yellowfin for an inbuild text-based charting library.


I'm not sure the tabbed approach is the best way to approach this problem. You can definitely use Grand Totals to show the full amount, however, this will appear on the last section as a Grand Total. You would have to change your underlying data somehow in order to get the result that you are after. See below:


/8b7283aa23cab9f9fc09e8d88368c301


/f365933e93c9c5c4295ecb16feeac0b6


For your third question, I think the best approach would be Access Filters, where certain rows or columns are filtered based on membership to a certain company for example.


Let me know if you have any further questions or need clarification.


Kind regards,

Simon

photo
1

Hi Luca,


I hope you're well.


I'm just messaging to check in with you to understand how you are traveling with this issue.


Please let me know if you have any further questions, or require any clarification and I will get back to you shortly.


Otherwise, I will shortly go ahead and mark this as closed.


Kind regards,

Simon

photo
1

Hi Luca,


I'm just messaging to let you know that I am marking this as closed.


Please feel free to reach out with any further questions and we will get back to you shortly.


Kind regards,

Simon