-
1. Re: Calculation based on Date not in Data Source
Joe OppeltJan 10, 2019 7:58 AM (in response to Wil Paulk)
A lot of what you're trying to do will depend on what your data looks like (and the density of values, and the data types).
Can you upload a packaged workbook?
If you are concerned about proprietary data, check out the video here:
Video demonstrates how to anonymize your workbook/data
I can tell you this: You can't create marks that are not somehow present in your data. Especially dimensional values.
You COULD create 12 separate calcs, one for each of the prior 12 months based on the value of TODAY(). And then use MeasureNames/MeasureValues to display them. Again, a packaged workbook would help me walk you through that.
-
2. Re: Calculation based on Date not in Data Source
Wil Paulk Jan 10, 2019 8:24 AM (in response to Joe Oppelt)Hi Joe,
I am unable to upload the workbook at present, but as soon as I have the opportunity I will upload. I appreciate your help!