MayaU_01 Member

Hello, I tried the split column with pipe symbol, but then i have to add a column names for all my expected values. But as i explained i do not know the exact count, the raw data can come with 100+ delimited values and then this will fail Hope you are referring to this

So do I need to use two group by tiles to first aggregate the month and then the Employee id?

Hi, I have used this method of LAG, but using this i am getting value of previous quarter in this quarter which is i think is the task of this function. I may have explained the question wrong. I thought to use that value but it will not help. My question is - I have columns, Client, Mydate column, Survey Value (A Beast…

Thank you Team.

I find some groups but some of them are not listed even if i try to search. I noticed i can see only closed groups in the list, the group to which i want to share is a dynamic group. So is it something which is limited.

Its in regards to the beta that We build with App Studio

It is giving me incorrect value. Basically in this method, we are subtracting 12 hours from the date difference and then we are also subtracting 12 hours from time value. So it is also subtracting date and then from the hours as well. check the column name Delta

Thank you

@nmizzell

I want a table, where First column gives infor for sub category, second gives all Commitments and then in the next columns I do have my actual and Goals. My actuals and goals are mixed format for this type of arrange ment, As per my requirement i cannot seperate this group of questions, because i cannot use more than one…

by aggregating i can fix the issue of duplicate value of commitment while multiple months are selected, but then the beast i am using to concat the % will not work. My bad, I dont have any quarter in data, its just Questions

Got the first part of the message. Thanks. I will check another way to it. Seems like a miss - the Q1 is a percent. I tried to use pivot, but the HTML table view is much cleaner which is preferred by the client. Any other suggestions.

Thank you.

Can you please guide on how i can add a MS form in my domo dashboard?

Thank you, This worked. There were spaces in data, after removing spaces it has worked.

I have limitations to edit it in etl. I can only do it in the beast mode. But as my data values only have Jan-23, Jun-23, May-22 etc, this is not letting me apply str to date.

@MarkSnodgrass after fixing with the recommended. I am still not able to get results. I verified the parenthesis they are correct. Here is what I updated: ( (SUM(CASE WHEN LAST_DAY(Date) = LAST_DAY(CURDATE()) THEN Headcount END) / COUNT(DISTINCT(CASE WHEN LAST_DAY(Date) = LAST_DAY(CURDATE()) THEN Date END)) ) - ( SUM(CASE…

@MichelleH My data has number of employee data which we are calling headcount. It is mentioned as days. So we have number of employees day by day. Our date coulmn has mmddyyyy. I tried to calculate total number of headcount for each month. If we consider we are in July so its our current month and the previous month will…