Dear All,

Hi, I would love to ask about date range  of MMM(e.g. Jan, Feb...) and yyyy(2019, 2021...)

<https://help.apptio.com/en-us/studio/data_studio/upload-data-file.htm?code=a615a3c7a45f9c9bf5db70dbaf500f2d4b434d33533afea73466e89959b3bede8f2f729d677413557263be53e8b52dbb&apptio-current-environment=09e6055e-1d1e-4ffb-94fb-b19d37bd0651>

I tested the date range about MMM and yyyy at my company's sandbox environment.

I input the data (below) as upload,

 
I changed the date range, however, the Date range setting and the date format doesn't work.

Does anybody have any ideas?

Thank you,

#ApptioforAll

What are you trying to accomplish?  Are you trying to date partition this table so that only the records with the MMM and yyyy that match the date range selector are shown?  If so, date partitioning requires both a month and a year in order to work.  So if you consolidated these tables together, you should be able to accomplish that.  For example, your cheeseburger record should have a MMM column of Jan and a yyyy column of 2009.  You could then create a Date column that concatenates those 2 values, so you end up with "Jan 2009".  You would then use this new Date column to do the date partitioning.

Be aware though, that when you use date partitioning, the records will only show up in the months that match the date range selection.  So in this case, cheeseburger would show up only in Jan 2009.  To get it to show up in every month of 2009, you'd need 12 records in the table: one for Jan 2009, one for Feb 2009, and so on.

Edit: technically, you don't need a yyyy... you should just be able to to partition on the MMM column, and I think the result would be that the Jan record would show up in Jan of every year that the table exists (i.e. if it's an ad hoc upload, it will exist in every year, whereas if it's a yearly upload, it will exist in Jan of the year you upload it to).


Original Message:
Sent: 04-15-2022 05:41
From: Hideo Yamada
Subject: About DateFormat function

Dear All,

Hi, I would love to ask about date range  of MMM(e.g. Jan, Feb...) and yyyy(2019, 2021...)

<https://help.apptio.com/en-us/studio/data_studio/upload-data-file.htm?code=a615a3c7a45f9c9bf5db70dbaf500f2d4b434d33533afea73466e89959b3bede8f2f729d677413557263be53e8b52dbb&apptio-current-environment=09e6055e-1d1e-4ffb-94fb-b19d37bd0651>

I tested the date range about MMM and yyyy at my company's sandbox environment.

I input the data (below) as upload,

I changed the date range, however, the Date range setting and the date format doesn't work.

Does anybody have any ideas?

Thank you,

#ApptioforAll

Hello @Hideo Yamada. I believe @James Funk has addressed the details of the Date Partition. You may want to refer to this other thread (link), where I provide some examples that look related to what you describe.
 
If you're looking for some kind of historical view, we have created a similar structure, so that we can report on multiple years:

With this technique, we can keep only 13 months online. This helps with calculation times.

Please note that we're NOT using a Date Partition in the backing dataset. 

If you need more details, please let me know.

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 04-15-2022 06:26
From: James Funk
Subject: About DateFormat function

What are you trying to accomplish?  Are you trying to date partition this table so that only the records with the MMM and yyyy that match the date range selector are shown?  If so, date partitioning requires both a month and a year in order to work.  So if you consolidated these tables together, you should be able to accomplish that.  For example, your cheeseburger record should have a MMM column of Jan and a yyyy column of 2009.  You could then create a Date column that concatenates those 2 values, so you end up with "Jan 2009".  You would then use this new Date column to do the date partitioning.

Be aware though, that when you use date partitioning, the records will only show up in the months that match the date range selection.  So in this case, cheeseburger would show up only in Jan 2009.  To get it to show up in every month of 2009, you'd need 12 records in the table: one for Jan 2009, one for Feb 2009, and so on.

Edit: technically, you don't need a yyyy... you should just be able to to partition on the MMM column, and I think the result would be that the Jan record would show up in Jan of every year that the table exists (i.e. if it's an ad hoc upload, it will exist in every year, whereas if it's a yearly upload, it will exist in Jan of the year you upload it to).


Original Message:
Sent: 04-15-2022 05:41
From: Hideo Yamada
Subject: About DateFormat function

Dear All,

Hi, I would love to ask about date range  of MMM(e.g. Jan, Feb...) and yyyy(2019, 2021...)

<https://help.apptio.com/en-us/studio/data_studio/upload-data-file.htm?code=a615a3c7a45f9c9bf5db70dbaf500f2d4b434d33533afea73466e89959b3bede8f2f729d677413557263be53e8b52dbb&apptio-current-environment=09e6055e-1d1e-4ffb-94fb-b19d37bd0651>

I tested the date range about MMM and yyyy at my company's sandbox environment.

I input the data (below) as upload,

I changed the date range, however, the Date range setting and the date format doesn't work.

Does anybody have any ideas?

Thank you,

#ApptioforAll