Dynamic data comparison using line chart

Venu Gopal K shared this question 1 year ago
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

Comments (2)

photo
1

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

photo
1

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