I'm working on this project and I'm not sure how to set up the functionality.
What I'm trying to set up is a stacked bar and line chart combo. For my dimension I want it to Month and Day. The stacked bars will represent paid and denied claims whereas the line will represent (paid+denied)/(paid+denied+incomplete) claims.
The first trouble I've run into is setting up the dimension because I'd like to add a special functionality to it. I'd like for the user to choose a [Date of Service] (split into month and day) which will update the lower end of the x-axis to that date. I want this to affect the expression so that it only shows claims that have that date of service as well. I'd like the upper end of the x-axis to use =today(2). I'm not sure how to activate the x-axis in order to do this.
The second trouble I've run into is the expression. Counting the status of whether they're paid or denied isn't the problem. I'd like to have their [Date of First Check] be the determining factor. It's kind of hard to explains I'll try an example:
User selects Date of Service (Month = August & Day = 2)
All claims with the date of service with August 2nd will be selected.
On the chart I should see those claims falling into place on the dimension by the dates they were paid or denied (calling it [Date First Check] for now til I get the kinks worked out). On each of those dates the stacked bars will show the percentage between those two - overall.
In other words, these claims that were selected for August 2. For these claims, lets say that on August 5th, 5% are paid and 3% are denied. Then say for August 10th, we see that 30% are paid and 6% are denied (these including the 5%/3% from before).
Then the line part of this chart will be a representation of (paid+denied)/(paid+denied+incomplete) overall.
I know all of this is a mouthful. Can anyone point me in the right direction to getting this solved?