Thanks HunterT and acordes for your responses. I may try the stacked container approach. I haven't used those yet. ... View more

@Sam_SAS @HunterT_SAS    I'm trying this: I've created a simple table (excel sheet) with 12 month numbers (1 through 12 for each month of year) and the corresponding month names in a second column.   Then I'm creating a calculated field in my main data that extracts the month from the Report Month -- so now I have a Month Number in both tables. I want to join these two tables on Month Number. Using a Left or Outer join. I'm hoping to force the 12 month numbers into the joined data, thus months with null patient count values will still be displayed.   I heard in a SAS Explore Training yesterday with Dominique Weatherspoon that I can only create a join using a Calculated Item with SAS Data Studio -- but it can't be done in VA. Do you know how to do that? I haven't figured it out yet. This is my first time in Data Studio... I can get to the join piece of it but I don't see the option to use the calculated field I created for Month Number.   Thanks ... View more

Thanks @HunterT_SAS . Just saw this response now. After I'd already replied to Sam. ... View more

Thanks Sam. Is there anything you can think of as a workaround? Such as grabbing a measure that is always populated for every month then using it as a Hidden value or something like that? I've been experimenting with that but haven't yet landed on anything that works.   How are your other clients doing this? It's a common chart to show: a years worth of values wherein some of the months have null values...   Thanks Mike ... View more

Thanks @Sam_SAS    We're getting closer. Using your formula we can generate a zero for a null when some other measure forces every month to display. However when we filter it down to our drug of interest -- if it doesn't have a value in every month -- all the null-now-zero values and months disappear.   With all drugs:   Filtered down to one drug:   ... View more

To add to the previous comment, here's an example of how VA visualizes for months with null data. We're trying to have zero displayed on the line chart when a month has null data; and on a bar chart (lower chart in pic) we're trying to have months display where the value is null.   @Sam_SAS is this something you might know how to resolve? Thanks       ... View more

Hi @armte did you ever figure out how to solve this? I too have a situation where I want my line chart to drop to 0 from months where there is null data. However the line chart just kind of skips over those null dates with a straight line which makes it appear that there is data for those null months.   Thanks! ... View more

The Midnight Theme is working for us, and the Legends fonts are legible. Thanks for the good suggestion. If there's anywhere we can request an enhancement for the Legends, please let me know and I'll do it. ... View more

Thanks Sam. It's not really the flexibility we were looking for but we may be able to make it work. And no way to change font size, correct? ... View more

Hi @Sam_SAS  We're having slow performance (report times out or errors out with a memory alert) . However we're on an old version so we're getting that updated and working with SAS Tech Support, then we will see if the report performs as expected. Aside from performance, the report does what we designed it to do. If we learn anything worthwhile during this process, I'll report back.   Thanks Mike ... View more

Thanks HB. However I have to do this in VA. Incidentally I did figure it out. The solution is in another post here:   https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-how-to-create-calculations-using-columns-data-in-a-List/m-p/827813/highlight/false#M16325 ... View more

Sam Yes I was able to add in the Date criteria by simply adding the Delivery Date to the Market Flag calculated item:   IF ( ( 'MARKET'n Contains 'p_RX MKT RT1'p ) AND ( 'DLV DTE'n Contains 'p_RX DTE RT1'p ) ) RETURN 2 ELSE 0   I'm using two Drop Down List Controls to create parameters for both the Market and the Delivery Date. In those controls, I select the Market and Delivery Date. Then the calculated item code, above, flags any data with the chosen Market and chosen Delivery Date as a 2 (else it is flagged 0).   I repeat this in a second object/List Table... I create the two drop down list controls, create the parameters, and create a second calculated item for a second flag (same code as above except I flag it 1 instead of 2).   In a third list table, using the same basic items I have in the first two list tables, I add the flags together. I have a filter on the object that is set to 3. Thus if the two flags are 1 and 2 (signifying that the data is in both the selected Market and the selected Delivery Date) they sum up to 3 and will show in the table.   I have a fourth table that does the same as above but I set the filter to 1 through 2; which shows me the drugs that are different among the two selected Markets/Delivery Dates.   Hope that all makes sense!   Thanks                 ... View more

Hi Madeline. Thanks for your response.   Version 2021.2.5 And I'm duplicating the page. I duplicated RX Compare 1.1 to create RX Compare 2.     Thanks Mike ... View more