shreeb Member

@GrantSmith @david_cunningham Can i use the unpivot tile to do unpivot 15 columns ?

@david_cunningham - i tried the ETL with date dimension. Will keep you posted!

So i asked the user, the by default want to find average for the week - total sqft / 5. and only exclude holidays for that week.

heres an example @JedP - 6/26 was not a holiday but its not getting considered for that week.

even if i am adding the holiday condition - since there is no data for a particular day, its taking only those days of the week that has a value.

but would that account for holidays ?? @JedP

SUM(SUM(`Orders`) FIXED(BY `AssignedTo`, `ProductionScheduleDate` - WEEKDAY(`ProductionScheduleDate`)))/AVG(COUNT(DISTINCT `ProductionScheduleDate`) FIXED(BY `AssignedTo`, `ProductionScheduleDate` - WEEKDAY(`ProductionScheduleDate`))) This solution worked but business now wants to change this to show average of 5 days and…

@marcel_luthi i have to update this logic and im not sure how.

I got a way to do it !!

I was able to make the emojis work !!! Thanks a lot @david_cunningham !! Thanks @ArborRose and @DavidChurchman !

Since I have sensitve information, is it possible to connect with someone who can help me with this? I cant bring in all the calculations and make it look pretty. Maybe if i connected with someone i could get an extra set of eyes?

Perfect !!! Thank you @ArborRose

@DavidChurchman - I was able to get the emojis to work on edge. Can you help me find more options on the emojis other than the red and blue circles? I tried using it from my MS teams but i was not able to copy them into my beast mode. Thanks!!

il try this and let you know @DavidChurchman

@ArborRose I tried that, but the user would have to scroll so much. I am trying to make it easier for the user to use. hence needed a pivot table.

Perfect! Thank you so much @ArborRose !

I understand that part @ArborRose - my question is. based on the PDP applied to the dataset, do I need to give individual access to the users because I cant send the group the alert.

Do i need to give individual access and depending on their group the will get the alert?

Thanks @MarkSnodgrass !!

thank you @DavidChurchman , @ArborRose , @marcel_luthi !

Im unpivoting in parts

I dont know how to explain 🤐

I am ready

Give me a 10 mins to get the proper details of the requirement

Sure!

I think it's a little more elaborate than that. I know it needs a workflow, and forms. I have created a form. When a new record is added to a card, the form is filled out, it should be able to get the email from the data in a card. and then send it

@marcel_luthi - Thank you again, it worked.!

@marcel_luthi - Its not exactly orders - but its a different metric. I used Orders to make it easier to understand. Your image is exactly what I am looking for! Based on your explanation - I will have to take the second approach and try to see if that works.

overall week average @MichelleH

@MichelleH - Its hsould show the same average for that week - if i change the timeline to This year - by Week - it should show the sum and avg by week