How: Line chart with Top10 lines (from 100)?

Florian KNUST shared this question 2 years ago
Answered

Hello YF-Community,

we would to generate

  • a line chart
  • with the Top10 (or Top5) customer revenues from the last 12 months per month
  • wehere the Top10 customers should be the ones which had the 10 highest revenues last month.

Have a look at the attached graphic we we modeled how it should look like.

The difficulty for us: The Top10 customers should be the customers with the highest revenues in the last month. So the Top10 (which should be displayed as a line chart) could change every month. We were not succesful in modelling it in Yellowfin. We tried to apply calculated filters, subqueries or top10-rankings. But: We didn't succed. so, question to the community: Do you have an idea?

Thanks in advance!

Florian

Replies (7)

photo
1

Hi Florian,

Thanks for reaching out. This type of content creation assistance is usually handled by our consulting department - do you know if you have and Extended Services time available with us?

You can use the Trim function on categories and apply a metric field to it, is this what you're looking for?


1f4a1f59f98a126286b654208febc647


You could possibly achieve this with freehand SQL as well.

Hope this helps! Let me know if you have any additional questions.

Thanks,

Eric

photo
1

Hi Eric,


thanks for our answer and apologies for my late reply (have been on holiday).

The trim-function doesn't appear in our line-chart series-setting.

Could you show me where to find the trim-function for the lince-charts?


Thanks in advance!

photo
photo
1

Hi Florian,

I'm going to go ahead and mark this Question as Answered at this time. Feel welcome to reach out in the future.

Thanks,

Eric

photo
1

Hi Eric,

I am not sure if my previous reply was sent correctly?

In short again: Where can I find the mentioned trim-function for line-charts?

In my Yellowfin there's no "trim" in the line-chart series settings (only in bar charts).

Thanks in advance

Florian

photo
1

Hi Florian,

I can make a request to developers to look into implementing this functionality in a future version of the application if you'd like, just let me know.

Thanks,

Eric

photo
1

> I can make a request to developers to look into implementing this functionality in a future version of the application if you'd like, just let me know.


Hi Eric,

yes, please, that would be awesome!!!

Best

Florian

photo
1

HI FLorian,

I was checking out dev platform and see this -

Trim Display menu available  on category line charts (non-time series).


So this might be a limitation of time series charts, can you try an A/B test to see if you have this option in some circumstances?

Thanks,

Eric

photo
1

Hi Eric,

yes, of course it exists for categories.

We need to show a timeserious of the Top10-Suppliers this year. Yet this Top10-list is dynamic. So we would like to reduce the "all suppliers list" down to the Top10 this year (or last 6 months, ...) and then show them in a timeseries line chart with values per month.


This looks like impossible with Yellowfin for us.


Any help appreciated.

photo
photo
1

HI Florian,

This type of content creation assistance is out of scope for support; feel welcome to contact an account manager for consulting opportunities on this.

Thanks,

Eric

Leave a Comment
 
Attach a file