shreeb Member

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

@MichelleH yup, i tried that, but still wasnt getting the right answer

@MichelleH - i tried your logic, but it didnt work the way i wanted. Here is the ideal scenario - #this is a sample. work can be 5-6-7- days

The final drill that I am creating is supposed to be the unaggregated view. This is the top layer. I added all the columns in the final drill. So when i click on 30 for A - it should show me 30 records but it shows me 1 record - for the date 3/10/2023

when i dont have prevent drill checked, its showing the right data. But when i create the drill with the same columns (without filters or sorts) its not working.

I dont have any filters, or sorts. theres a count(id) and max(date the ids were created) —→ drilling to last layer to see those IDs and Created dates

Thanks @ColemenWilson - I am aware of 1 and 2. I will try 2. again and let you know soon !

@ColemenWilson - just did !

Thank you !! that worked