Weekly trend of data growth.

[sdhn]

Hello All,

I have 5 weeks of data for the same month.

I want to display weekly total in the visualization.  So user can see weekly trend of data growth. I also want grand sum total on same visual.  

Currently I am dispaling data but it is displaying data value of whole month. (sum).  I want to break down on weekly on the same visual.

.

 Any help will be appreciated.   Thanks 

[sdhn]

Actuallu I want sorting too. in same visual.   Getting weekily breakdown data , i picked staked column chart. 

example:

week 1 -- 100

week 2-- 90

week 3-- 50

week 4- 100

week 5 - 70 

80 to 100 -- high

60 to 80  -- medium

60 & lower - low 

i will assign RED color to High, Yello to Medium and Green to low 

[Fowmy]

@sdhn 

You need to add a week number to your table and use it in the visual

Week = WEEKNUM([Date])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn