Forum Discussion

Cednok's avatar
Cednok
Frequent Visitor
5 years ago
Solved

Need help for creation a graph

Hi the Community,

 

I need help for creation a graph

 

I have these datas

 

For the graph i want to display value2/value1 by week

 

Can you help me please ?

 

Regards

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Cednok 

    Create the following measure, replace your table name and column names then add the weeknumber to a chart (line chart) and add the measure:

    Measure = 
divide(
	sum(table[value2]),
	sum(table[value1])
)

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Cednok 

    Create the following measure, replace your table name and column names then add the weeknumber to a chart (line chart) and add the measure:

    Measure = 
divide(
	sum(table[value2]),
	sum(table[value1])
)