APAC SD Team
Category
Report Builder
Product Version
7.4
Total Line in Charts
Idea Logged
In 7.2 you introduced Functions to the charts of Yellowfin
There's Trend, Average, Accumulation and Forecast.
Is it possible to add a "Total" function ? see an example below.
We are currently solving it by creating an Append, which makes users work harder.
If you have multiple lines and you want to total them all, like so - (black line)
Bests
Dor & Tal
I like this idea 
Hi Tal,
Thanks for your feedback,
I understand what you're after, but honestly the effort involved in supporting such a feature outweighs the simple task of creating a calc field with both metrics summed.
I know this is not the answer you would like to hear, it's just that adding a 'total' line is not as simple as it sounds, but creating a calc field that is 'column 1 + column 2' usually is quite simple ;).
If there is something I'm missing here, please help me understand how you're report is configured to see if there is another alternative.
Thanks again!
David
Hi Tal,
Thanks for your feedback,
I understand what you're after, but honestly the effort involved in supporting such a feature outweighs the simple task of creating a calc field with both metrics summed.
I know this is not the answer you would like to hear, it's just that adding a 'total' line is not as simple as it sounds, but creating a calc field that is 'column 1 + column 2' usually is quite simple ;).
If there is something I'm missing here, please help me understand how you're report is configured to see if there is another alternative.
Thanks again!
David
Hey David,
Thank you for your reply.
It's not as simple as you suggest due to the type of request here.
It will work when you have one metric without a breakdown. Here we have a case with a field that divides the result into multiple types and has a single metric, and we would like to use the color option in order to differentiate between them. The line chart does not support the color option if its not a cross tab for example..
And even then, it's not that easy to just adding columns when you have a single column.
It's not easy or even impossible to just create a calculated field with a clause here. It is necessary in this case to create an append which will not be affected by the type dimension.
Which makes the user experience more difficult and not user friendly. :)
Maybe if the system knew how to duplicate queries - then I wouldn't be worried about that. You can actually take another idea from here - Copy Filters function.
When we want to create appends to measure the same data but in different times (offsets or anything similar) - we need to make a new append with the same filters to receive the same data, and just change the time.
The problem lays when we have a huge clause with multiple defined filters.
If we just had a button that would copy the filters with the defined values, that would save has 40% of the time we spend on building such a report.
Let us know what you think....
Bests
Dor & Tal
Hey David,
Thank you for your reply.
It's not as simple as you suggest due to the type of request here.
It will work when you have one metric without a breakdown. Here we have a case with a field that divides the result into multiple types and has a single metric, and we would like to use the color option in order to differentiate between them. The line chart does not support the color option if its not a cross tab for example..
And even then, it's not that easy to just adding columns when you have a single column.
It's not easy or even impossible to just create a calculated field with a clause here. It is necessary in this case to create an append which will not be affected by the type dimension.
Which makes the user experience more difficult and not user friendly. :)
Maybe if the system knew how to duplicate queries - then I wouldn't be worried about that. You can actually take another idea from here - Copy Filters function.
When we want to create appends to measure the same data but in different times (offsets or anything similar) - we need to make a new append with the same filters to receive the same data, and just change the time.
The problem lays when we have a huge clause with multiple defined filters.
If we just had a button that would copy the filters with the defined values, that would save has 40% of the time we spend on building such a report.
Let us know what you think....
Bests
Dor & Tal
Hey David !
Is there any update with this idea ?
Hey David !
Is there any update with this idea ?
Replies have been locked on this page!