Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
6 years ago

Weekly trend of data growth.

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 

 

 

 

 

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    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

  • sdhn's avatar
    sdhn
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

    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