Sharon
- Total activity 13
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 3
Activity overview
Latest activity by Sharon-
Sharon commented,
Hi Konsta, I have done that, and don't see the update. I am available now if you can do... Thank you very much, Sharon
-
Sharon commented,
Just as an aside, the documentation does state to use a multi join with multiple columns but does not state anything about a TWO_MEMBER_JOIN. Can you please advise? Thanks again, Sharon Creating...
-
Sharon commented,
Thank you, Konsta. I am only using the file -> Join option and yes, trying to select multiple columns. I suppose this is the equivalent of your explanation of using a MULTI_JOIN to join Sheet1 and...
-
Sharon created a post,
Can not create join: All sheets of 'JoinPair{parsedata![dma_name]<=>work_MultiZipCode_GetMultiZC![DMA]}' do exist in previous pairs
Hi, Can you kindly explain what this error means? I am trying to create a joined sheet. Similar posts do not reveal an answer, unfortunately. Thank you in advance!
-
Sharon commented,
Hi Konsta, The dataset is not being appended to. It's one dataset with various dates, but for this pivot, I need to get the max reporting_month_date from the dataset and use that to determine the ...
-
Sharon commented,
Hi Konsta and all,Sure, here is a sample: reporting_month_date is formatted as date format. sample:reporting_month_date salesJan 2018 293.81Mar 2018 109.95Sep 2017 500.82Jan 2018 5.00Apr 2018 250.9...
-
Sharon commented,
Thank you, Brian! I asked because when I ran my nested version, it returned blanks with no error. I'm not sure why. Thank you for the confirmation!
-
Sharon created a post,
get the last twelve months, then create a pivot on those dynamic months
Hi, I suppose my question is two-part: 1. How is the best way to determine each month for the last 12 months from a max date in a column? 2. I would like to create a pivot using those dynamically-d...
-
Sharon created a post,
multiple functions on a column?
AnsweredHi, I'm new to datameer. Is there a way to execute multiple functions on a column, or is it one function per column? For example: Two columns: FORMATDATE(#parsedata!reporting_month_date;"MMM yyyy"...