Hello,
I have an excel document that my team plans to make into a dossier.
Now the excel has Current Month|Previous Month tabs for the information. I was able to make a cube and then make a dossier that shows the current month info, but trying a lag function to show previous month doesnt work. Another idea I had was to create duplicate metric with custom expression for previous month, but not sure how to do that.
What other ways can I achieve this that when current month is selected previous month is also show?
My filter is in yyyy-mm format, its datatype is text. Would it make sense to use individual attributes for years and month? We have that in out database, that could help in achieving this I guess?
I have attached excel document picture to give better idea.
Thanks
I have an excel document that my team plans to make into a dossier.
Now the excel has Current Month|Previous Month tabs for the information. I was able to make a cube and then make a dossier that shows the current month info, but trying a lag function to show previous month doesnt work. Another idea I had was to create duplicate metric with custom expression for previous month, but not sure how to do that.
What other ways can I achieve this that when current month is selected previous month is also show?
My filter is in yyyy-mm format, its datatype is text. Would it make sense to use individual attributes for years and month? We have that in out database, that could help in achieving this I guess?
I have attached excel document picture to give better idea.
Thanks