asked on November 30, 2022
Hello,
We are trying to re-create the attached in Flexmonster.
We would need to have columns with separate date filters on them. Is this possible?
We are using a "microsoft analysis services" as our datasource.
Kind regards,
⋅ December 2, 2022
Hello, Craig!
Thank you for reaching out to us.
From our perspective, it seems that you would like to show two columns side-by-side with different filters applied to each of them. If this is the case, Flexmonster does not provide such functionality. However, you can create custom measures on the cube to represent the current and previous 12-month periods. For example, one measure could contain the values with dates in the current 12 months, another could contain the values with dates from the previous 12 months, and the third - all older values. You are welcome to check this Microsoft Guide for creating and managing measures with SSAS Tabular.
For creating a doughnut chart similar to the one in the attachments, it is possible to integrate Flexmonster with a third-party charting library: https://www.flexmonster.com/doc/available-tutorials-charts/.
Please let us know if creating the custom measures would work for your case.
Best Regards,
Maksym
⋅ December 14, 2022
Hello, Craig!
Hope you are having a great week.
Our team is wondering if you had a chance to look through our previous answer.
Could you please let us know if creating the custom measures on the cube would work for your case?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ December 14, 2022
I think this will work for us we just haven’t had chance to implement it yet.
⋅ December 14, 2022
Hello, Craig!
Thank you for your swift response.
Your feedback is valuable to our team, so we'll be waiting for the following updates on the matter.
Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ January 10, 2023
Hello, Craig!
Hope you are doing well.
We would like to know if you had time to try creating the custom measures on the cube.
Our team will be glad to hear your feedback.
Best Regards,
Maksym
⋅ January 11, 2023
Hello Maksym,
We were able to create a custom measure of if the data was from the current 12 months, previous 12 months or older. That way we didn't need to create two new measures each time we wanted to do this with other measures.
Kind regards,
Craig Button
⋅ January 11, 2023
Hi, Craig!
Thank you for your feedback.
We are glad to hear that you were able to find the solution.
Feel free to contact us if more questions arise.
Best Regards,
Maksym
