Select multiple measures at one time and add to a series

How can we select multiple measures at one time and add to a series?  We have approximately 900 measures that we want to add to the card and be able to filter 4 ways? Thanks in advance for your help!

Comments

  • PodiumMason
    PodiumMason Contributor

    Hey @user09698,

     

    The answer to this question kinda depends on how your data is structured. Is your dataset wide? Structured something like Date, TotalRevenue, TotalCost?

     

    Or is it a tall structure something like this: Date, Measure Type, Value.

     

    If the data is wide, you might want to think about using Magic ETL to pivot your data so that it is stacked taller, it will probably make it easier to do what you're looking for. 

     

    In the tall structure, simply add your X-Axis value, your Y-Axis value will be the SUM of your value column, and the series will be the "Measure Type". Then filter your graph on "Measure Type" to only show the few measures you want to see on the card.

     

    Let me know if this makes sense or if you have any additional questions.

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.