How to use a Report data as another report datasource in Yellowfin7.1

leejunru shared this question 6 years ago
Answered

Hi Yellowfin,


I have a question. I have a report which do sum(leave_days_applied) and group by staff no. and I wish to use this data set to create a report which group the sum(leave_days_applied) and count how many staff in each category leave apply day in <50 days, 100 days and 150 days in annual.

If use query is something like:

SELECT a.total_leave, count(a.total_leave) as no_of_staff

from(

SELECT staff_no, sum(leave_days_applied) as total_leave

FROM leave

where leave_date between '2015-01-01' AND '2015-12-31'

Group by staff_no

) a

GROUP BY a.total_leave


Can I create this kind of report using drag and drop wizard instead of using SQL Query in Yellowfin 7.1?


Thank You.


Regards,

JR LEE

Replies (3)

photo
1

Hello,


Unfortunately report on report was not possible until Yellowfin 7.2 by using the drag and drop wizard.


If you would like to report on report, we highly recommend upgrading to the latest version of Yellowfin.


Please also be aware that support for 7.1 has officially finished and we are encouraging everyone still on this version to plan their upgrade to a supported version ASAP.


Best regards,

Pete

photo
1

Hi Peter,

As you said, Creating report on report is now possible using YF 7.2 onwards.Could you please share its video tutorial on how to create a report on report.

Thanks.

photo
1

Hello Mukta,


we don't have a video guide, but we do have a text one!

Please take a look here:

https://community.yellowfinbi.com/topic/can-i-save-my-report-as-a-view


This covers how to use your report as a view to create other reports from.


Best regards,

Pete

Leave a Comment
 
Attach a file