Creating Percentages

I have a data set that is split by many levels (country/month/product type/channel) and what I want to see is the % share by month, but I want to be able to change the quick filters so it will work this out on the fly and also be able to see this at a quarter level and a year level. For example I want to see the US and UK % market share in the same line graph, but then be able to filter to only the UK and this will work out the UK % market share only. 

 

Any thoughts?

Comments

  • Hi,

     

    If I correctly understood your question, one idea would be to create an unfiltered BEASTMODE to calculate the percentage and then let the quick filters filter what data goes through.

     

    Hope this helps, don't hesitate to ask if you have more questions on this.

  • Hi,

     

    Thanks for taking the time to answer my question. I am fairly new to domo and have limited experience using Beastmode, are you able to elaberate on how I am able to do this?

     

    Regards

  • Hi,

     

    Can you be more specific?

     

    Maybe send me a layout of your data and the formula you want to calculate, I could help you further then.

     

    Anyway here is some more info on Beast Modes:

     

     http://knowledge.domo.com?cid=beastmode

     

    Regards

This discussion has been closed.