Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

Clustered Column Visual

I have the following visual which uses filter  It is set less than 4 Top 3 by frequency  =   IF (     ISBLANK ( [Count of Total Gross Incurred] ),     BLANK (),     RANKX ( ALL ( InjuryCause[Ca...
Need Help
  • bdehning's avatar
    bdehning
    2 years ago

    I solved the issue by adding both Cause and LOE to my X-Axis.  

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bdehning ,

I think we should change it here.

Assuming that the column 'Cause Grouping' has the values 'No Data','<1yr','yr', and you have cleared the filtering capability of the field using the ALL function, the 'Ref values should all be the same, for sorting all are 1

bdehning's avatar
bdehning
Post Prodigy
2 years ago

I was trying this earlier and trying to figure out What is Sheet1 and Sheet1[Type] and then Col2.   I Assume Sheet1 is Injury Cause and Type is Cause Grouping.  Not sure what Col2 is for me?   Its Either Count of Total Gross Incurred or LossRun[LOE 2023]?