New Topic
CommunityTopicQuestionChart Builder
Following
photo
Eric Hagfors
Yellowfin Support Team
Assigned
Properties
Category Chart Builder
Product Version 9.0

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

Florian KNUST shared this question 21 months 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

Files: top10 line char...
2 The same question

Replies (7)

photo
1
Eric Hagfors ● 21 months ago

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

Reply
photo
1
Florian KNUST ● 20 months ago

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
Eric Hagfors ● 20 months ago

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

Reply
photo
1
Florian KNUST ● 20 months ago

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

Reply
photo
1
Eric Hagfors ● 20 months ago

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

Reply
photo
1
Florian KNUST ● 20 months ago

> 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

Reply
photo
1
Eric Hagfors ● 19 months ago

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

Reply
photo
1
Florian KNUST ● 19 months ago

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
Eric Hagfors ● 19 months ago

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

Reply
Leave a Comment
 
Attach a file