Histogram - No numeric values on x-axis?

[NickHoff]

I'm attempting to create a Histogram for my data, which I already have the bins.  For my dimension I'm using the following:

=$(eCostLevel)

Which is @CostDescriptionField in the inline table below:

CostLevel:

LOAD * INLINE [

@CostLevelID, @CostLevel, @CostDescriptionField

1, HCA, HCACostDescription

2, Group, GroupCostDescription

3, Division, DivisionCostDescription

4, Market, MarketCostDescription

5, Facility, FacilityCostDescription

];

In my data model I have an indicator assigned to each @CostLeveID ranking from 1-8 depending on where in the innerquartile range the ID falls based on their Cost Per Case compared to a Benchmark.  The description is created with the following for each CostLevel:

     FacilityCostScore,

     IF(FacilityCostScore = 1, 'LESS THAN 1.0%',

      IF(FacilityCostScore = 2,'BETWEEN 1.1% and 5.0%',

      IF(FacilityCostScore = 3,'BETWEEN 5.1% and 25.0%',

      IF(FacilityCostScore = 4, 'BETWEEN 25.1% and 50.0%',

      IF(FacilityCostScore = 5,'BETWEEN 50.1% and 75.0%',

      IF(FacilityCostScore = 6,'BETWEEN 75.1% and 95.0%',

      IF(FacilityCostScore = 7,'BETWEEN 95.1% and 99.0%',

      IF(FacilityCostScore = 8,'GREATER THAN 99.1%')))))))) AS FacilityCostDescription

My expression in the table is the following:

=COUNT({[Benchmark]<ProcGroup = {$(eProcedureGroup)},ZeroSurgicalUsedWastedIND = {'No'}>}DISTINCT SurgicalCaseSk)

All the data displays correctly until I check Continuous on the axes tab, then I'm greeted with the following error:

[sunny_talwar · Accepted solution]

May be try with Dual function in for your dimension:

FacilityCostScore,

    IF(FacilityCostScore = 1, Dual('LESS THAN 1.0%', 1),

      IF(FacilityCostScore = 2,Dual('BETWEEN 1.1% and 5.0%', 2),...

          ))))))) AS FacilityCostDescription

[NickHoff]

That works, but how can I get the dimension to display the correct labels instead of 1-8?  I could always make a legend.

[sunny_talwar]

I am not sure if you would be able to do this with continuous axis. I am not 100% sure though.