Category
Report Builder
Product Version
7.3
Dynamic data comparison using line chart
Answered
Hi,
I have requirement to compare the year-by-year comparison dynamically. Suppose i have data starting from 2010 to 2017.
My requirement is to compare the data between 2010 and 2016, here the year selection should be dynamic like using filters/prompts.
Is ther eany way to achieve this?
Thanks,
Venu
The same question
Hi Venu,
Your best bet here will be to use append sub-queries to split this data apart. The master and sub-query could each have their own filters, which could be set to user prompt.
The data contained within each would be specific to that time range, and your line chart could pull one metric field from each query.
Let me know if this makes sense / sounds like it will work.
Regards,
Nathan
Hi Venu,
Your best bet here will be to use append sub-queries to split this data apart. The master and sub-query could each have their own filters, which could be set to user prompt.
The data contained within each would be specific to that time range, and your line chart could pull one metric field from each query.
Let me know if this makes sense / sounds like it will work.
Regards,
Nathan
Hi Venu,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Hi Venu,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Replies have been locked on this page!