Most effective way of plotting a stacked bar with a trend line chart (1 Dimension + 2 Measures)

Lwi Tiong Chai shared this question 2 years ago
Answered

Hi Support,


I do have a question regarding what is the most effective

way of plotting a stacked bar with a trend line chart. Currently, we have a

customer requirement we cannot meet directly with YF functionality (seems to be

a limitation) – based on your implementation experience, when customer ask for

this, what would you do or suggest as solution?


I have no problem creating a

stacked bar with a line chart trend if it is within the same dimension by using

a Pivot table. (Example: Columns -> (Company, Amount (Sum)) and Rows ->

Period) and YF allows me to compare within the company performance by choosing

within the chart series and select the stacked bar or line graph accordingly.

However, the problem comes when I want to compare all company performance in additional

to another measure from another field. This time will be (Example: Columns

-> (Company, Amount (Sum), FI Amount (Sum)) and Rows -> Period). From

here, I want to be able to compare the accumulated FI Amount (Sum) in each

period with respect to each period accumulated stacked bar for the companies.

In the chart section, YF does not seems to be able to allow me to drag and drop

the FI Amount (Sum) as the error shows Field Limit Reached.


To workaround this problem I am facing, I used sub queries

to append all the individual companies and finally the FI amount for the period.

This will allow me to create the stacked bar and line trend chart that I wanted

but in terms of filtering I will have a problem because during the append of

the sub queries I have already filter based on company name to get those data

and doing a LEFT OUTER JOIN to the MASTER QUERY which is my period in this case.


In terms of long term feasibly and maintainability, I

personally do not think my idea is the best way to do it because assuming we

have 10 reports that is using the sub queries method above and client wants to

add 3 more companies hence we will need to add 30 sub queries to the reports

and we could accidentally missed out some reports which could be a nightmare.


Is there a more efficient way of doing it? Seems that I am not

able to find an answer in the wiki and the community forum?

Comments (3)

photo
1

Hi!


Sorry for the delayed response to this ticket. I unfortunately think that your theory is correct about coming up against a limitation of Yellowfin. I too agree that completing the report/chart set up with so many sub queries is not likely to be easily sustainable. I think that we are probably at an impasse here, but I want to reach out to one or two folks just to make sure that I'm not missing anything here. Please stay tuned for an update, I hope to have something for you soon!


Thanks,

-Conner

photo
1

Hi,


Thanks for your reply. Would it be possible to add this requirement into the new releases as it seems to me that we might need to create many different version of this kind of charts in the future for our clients.


Thanks.

photo
1

Hello,


I've just been informed that this is likely possible to accomplish using the new set analysis feature in Yellowfin 7.3. If you could take a look at the Set Analysis portion of the following wiki page, that would be great!

http://wiki.yellowfin.com.au/display/USER73/Chart+Functions?src=search#ChartFunctions-SetAnalysis


Thanks,

-Conner