Evolution of value per id filtering by date
Hi, I have been investigating on the forum but still have some issues. I have a table like this: Id Date Value 1 1/1/2020 Prospect 1 2/2/2020 Lead 1 5/5/2020 Opportunity 2 3/3/2020 Prospect 2 4/4/2020 Lead 2 7/7/2020 Opportunity I need a measure that shows the last value by id filtering by month. For example, if I select march/2020 I need to have something like: Id value 1 Lead 2 Prospect Then, I need to display a chart that shows the number of distinct id´s per value filtering by month If I select 5/5/2020, I need to see something like: Value Count of id Prospect 0 Lead 1 Opportunity 1 This means, we count the number of id´s per value, depending on the last value of an id at a certain date
Help Changing Funnel Plot Colors and Shapes of Specific Data Points
I just starting creating Funnel Plots for Medical Center data where I plot Regions or Facilities. I use a count as 'Occurrence' and PBI create the Ratios. Can someone help with these issues? 1) How can I see the values that are created for the Y-axis Ratio for each plot? 2a) How can I see what PBI calculates as the Upper & Lower Confidence Limits? I specifically want to know what the 2nd CL is that I set at 99.5%. 2b) These 99.5% CL values are needed because I want to change the color of the circle to RED if the plot (Facility or Region) falls Above the Upper 99.5% CL, and change to GREEN if the plot falls Below the Lower 95.5% CL. Can you tell me if & how to do this? 3) How can I change the SHAPE from circle to Triangle or a Diamond just for ONE plot (Facility or Region) ? SAS is able to do this with this syntax: "markerattrs=(symbol=diamondfilled)" Thanks, Craig