Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Appropriate Visual to show those data

Hi all!! 

 

I am searching for a graph to show some data to my boss.

 

the Data is structured like this:

Type of Contract CalculatedValue ContractLimit Check
Average Time 6.84375 7 OK
Average Time 5.875 7 OK
95% of success 87.5 95 KO
95% of success 75 95 KO
Average Time 2.8 8 OK
Average Time 1 8 OK
Average Time 5.65530303 8 OK
Average Time 6.583333333 8 OK
100 % of success 100 100 OK
100 % of success 100 100 OK
100% of success 96.59 100 KO
100% of success 100 100 OK
55 % of success 100 55 OK
55 % of success 100 55 OK
55 % of success 84.47 55 OK
55 % of success 50 55 KO
95% of success 100 95 OK
95% of success 100 95 OK
95% of success 96.59 95 OK
95% of success 100 95 OK

 

as you see, every contract has a limit (percentage or average), the first problem is that all those informations are in the same table from the database, I cannot change the source.

 

My expected output should be a graph that shows the calculate value for each Type of Contract (use just the average or the MIN of CalculatedValue) and also the Limit, so that who read can see immediatly if for each Type of contract, we are above or below the ContractLimit. The challeging part is that 3 contracts work in the same way (with percentages) while the other one works with average of days, so there also is a problem with number dimension (95 versus 8 for example)

 

Do you have some idea? 

 

thanks a lot!

Need Help

2 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    HI Anonymous ,

     

    Will something like a combo chart work for you?

    I have taken Min of Calculated Value and Average of Contract Limit on the chart.

    Also, I don't understand the last part of your query where you are saying there is a challenge? Do add more details to make it clear.

     

    Thanks,

    Pragati

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    The Value in the visual object can only place the same type of data, you can place it in Tooltips, and move the mouse to display it

    Here are the steps you can follow：

    1. Create measure.

    Measure_CalculatedValue =
AVERAGEX(FILTER(ALL('Table'),'Table'[Type of Contract]=MAX('Table'[Type of Contract])),[CalculatedValue])
    Measure_ContractLimit =
IF(
    MAX('Table'[Type of Contract])= "Average Time",FORMAT( AVERAGEX(FILTER(ALL('Table'),'Table'[Type of Contract]=MAX('Table'[Type of Contract])),'Table'[ContractLimit]),"Standard")
    ,FORMAT( AVERAGEX(FILTER(ALL('Table'),'Table'[Type of Contract]=MAX('Table'[Type of Contract])),'Table'[ContractLimit])*0.01,"Percent"
))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly