IN DEVELOPMENT

Need Funnel Chart - Ability to decide if I want all data in one stacked column

  • 17 November 2016
  • 7 replies
  • 29 views

Userlevel 7
Badge +1
I think a funnel chart would accomplish this but currently I am unable to create a stacked chart with a 1:1 (show me/by) that gives me all the data in one column. The by field always breaks out the columns. The only way to get close to this is to put another field in the by section that is in common with all records like a date set to show yearly, monthly, etc. The problem is when I add the date field if it spans over two years and I want to display it all in one column I am never able to do this. It would be nice to just allow me to use a 1:1 with show me /by fields and decide if I want it all in one column stacked chart or more columns. 


7 replies

Userlevel 7
Badge
Can you describe more about the use case report you are trying to create, Andrew?  
Userlevel 7
Badge +1
Yeah, I tried but I can see how it was not really clear. I need to be able to create a stacked bar chart that only has one stacked column of the total sum of cost for escalations by the type of escalation. The problem is I get multiple bars even if I select stacked columns. The only way I can get this is by selecting a date range of current fiscal year and but the created date in the by field setting it to show yearly so it only shows 2016. Problem is I will get two stacked bars when I move into 2017 and have to change the filter to include last year. 
Userlevel 7
Badge
I tried it too and got the same thing - it is not showing a stacked bar
Userlevel 7
Badge +1
Right. A funnel is a neat way of showing it and would be cool but stacked bar would be fine as well if it worked how I thought it would...maybe this is WAD?
Is there an update on this feature? 
Userlevel 5
Badge

+1 for idea to incorporate funnel chart in reports 2.0 and data designer.

Userlevel 7

Hi all.

Want to update that we have picked up Funnel chart capability in our new Horizon Analytics for development. We should be able to deliver this in short term horizon.

Reply