How do you restrict the summary number to only sum the top x rows (already filtered in show x rows)?

Johndogg
Johndogg Member
in Archive

I'm trying to have a summary number total the top 20 opportunites in our pipeline. I've restricted the chart to only show the top 20 by the "show only 20 rows" option and sorted by size of deal. However the summary number totals the whole pipeline and not just the 20 rows that have been filtered when viewing the card. Does anyone have any idea on how to restrict the summary number to just the top 20?

Comments

  • Unknown
    Unknown

    Hi all,

    Can anybody help out @Johndogg?

    Thanks!

  • Unknown
    Unknown

    If you can add a column to your data flow that would flag an opportunity as a "Top 20" opportunity. You could use this to create a beast mode that would sum only those opportuntities with the "Top 20" flag. 

     

    This could be used as your summary number instead of the standard series total.

  • Johndogg
    Johndogg Member

    Yeah, that would work if you always wanted the top 20. However, it would be much more helpful to have the summary number dynamic if you change it from top 10 to top 20 for example. 

     

    Thanks for the idea!

  • Unknown
    Unknown

    @Johndogg, did @Kung-fu_Panda's reply help you out?

  • Johndogg
    Johndogg Member

    Domo support reached out and this is currently not possible without building a static dataflow. They are putting in a functionality request to the dev team for this feature. 

     

    Currently you must build a dataflow and aggregate the data to a set number of rows. You would then need to change the dataflow for every change in x rows (ex: top 20 to top 30). 

  • Unknown
    Unknown

    @Johndogg, thanks for the update!

  • Angelyson
    Angelyson Member

    Do you guys have any new solution to this question? I see that this was posted a couple of years back so I am wondering if there have been any updates to Domo that would solve this issue more efficiently. I am undergoing the same issue and need to show totals based on Top 10 values not all values. Many thanks!

  • Jsun82
    Jsun82 Member

    You could fix this in an ETL transform by using the rank function to create a new column.  Then you could use that column as a filter to get the top 10, top 20, or whatever version of this you would like.

     

    Hope this helps!

  • clairecat
    clairecat Member

    Has this been resolved now? I'm trying to make table charts to only show the 20 highest revenue sales and I need it to only total the rows showing. 

    When I add a total row/summary number, it is totalling the entire value on the dataset and not the 20 rows which are being shown. Don't see an option to change it?

This discussion has been closed.

Categories