You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Can someone please assist. I have an EazyBI report that filters based on "january this year and next month" however the business user wants to see the total rural estimates for a rolling 12 months and compare them to the previous year. For example: Rural estimates created in January 2022 as compared to January 2021.
For the total estimates for a rolling 12 months, I recommend using the predefined Time dimension calculated member "Last 12 months" in the report rows and the desired measure returning the estimate.
For the previous year, you can take the formula from the "Last 12 months" and adjust it to the one below:
[Time].[Month].DateMembersBetween('24 months ago', '12 months ago')
And define a new calculated member in the Time dimension. See more details on defining calculated members on the eazyBI documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember.
The report then could look similar to the one below:
Roberts // email@example.com
@Roberts Čāčus thanks for your quick response. I appreciate the level of detail you provided because I am just beginning to learn eazyBI.
Currently the report looks like this:
But I want it to look like this:
And I thought I could change the filter in the red box to display the results differently.
Finally, can you recommend any eazyBI training that I could take? I am very green and finding eazyBI a real challenge to learn. I do best with videos but anything is great!
Thanks so much!
Hi @Nicole Gosling ,
I think I misunderstood your requirement with my initial answer. Correct me if I am wrong (again) - for each month, you want to see current data and compare it to the data from last year of the same month.
In that case, I recommend selecting the desired measure in rows and then using the eazyBI standard calculation "Time ago"->"Year ago" on the measure. That will create a new measure in this report, displaying the desired data. Please see the eazyBI documentation page for more details on standard calculations - https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure.
The filter on the Time dimension you highlighted in your screenshot will affect the Time dimension members visible in the rows. See more details here - https://docs.eazybi.com/eazybi/analyze-and-visualize/date-filters.
And training videos - https://docs.eazybi.com/eazybi/learn-more/training-videos. The whole documentation page is a helpful resource, but you can also look at the eazyBI community site - https://community.eazybi.com. Some of the questions you have might as well be answered there already.
Let me know if I missed anything.
Roberts // firstname.lastname@example.org