How to split week and calculate percentage

[tyan]

here is the database.

I would like to see following graph. I dont know how to calculate week and split them up. Week: ( oc ship- final pass)  which the result is in column G.

After finiding weeks, I need to splirt them into  on time( yes), 1week, 2 weeks 3weeks, 4weeks etc..

and them need to split by app(apperal) footware(fw), hardware(hw) .. 

and calcualre the quantity.

[v-yiruan-msft · Accepted solution]

Hi @tyan ,

You can create a calculated column as below to get the status:

On time? =
SWITCH (
    TRUE (),
    [Column G] < -28, "4 week+",
    [Column G] >= -28
        && [Column G] < 21, "4 week",
    [Column G] >= -21
        && [Column G] < 14, "3 week",
    [Column G] >= -14
        && [Column G] < 7, "2 week",
    [Column G] >= -7
        && [Column G] < 0, "1 week",
    [Column G] >= 0, "On time"
)

Then create a culstered column chart with the settings(Axis: On times?  Legend: BU  Values: xx)

If the above one can't help you get the desired result, please share some sample data with Text format and your expected result with backend logic and special examples in order to provide a suitable solution. Thank you.

Best Regards

[tyan]

It works well! thank you for helping me 

[v-yiruan-msft]

Hi @tyan ,

Thanks for your feedback. It's glad to hear that it can help you. Could you please mark the helpful post as Answered? It will help the others in the community if they face the same problem with you. Thank you.

Best Regards

[amitchandak]

@tyan Create a new column like

var _q = quotient(abs([final ins]),7) +1 ,

Switch(True() ,

[final ins] = 0, "  On Time" ,

" Week" & _q )

and use that visual

[tyan]

@amitchandak  hi, thank you for helping me. It doesnt work tho.