Solved: Need help for creation a graph

Cednok · ‎05-28-2021

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

Fowmy · ‎05-28-2021

@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])
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎05-28-2021

@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])
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

Cednok · ‎05-31-2021

Thank you very much

Need help for creation a graph