How do I show the number of organisations in a category per month?
I have a Bar chart that shows Issue count by month, the hierarchy is by category, what I would like to show on a separate axis is the number of organisations per month on top of the issue count (so if issue count rises or drops hopefully so will the number of organisations).
Any suggestions would be useful.
Please try to use the Count() function in combination with the Filter() and Descendants() functions to count the Organization dimension members. The calculation could look similar to the one below:
[Measures].[Issues created] > 0
Please read more about the mentioned functions on our MDX reference guide and calculated member on our documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members.
Roberts // eazyBI support