Forum Discussion

dinda156's avatar
dinda156
Cloud Apps
06-06-2024
Solved

Counting by the Day of the Week in a Pivot Table

Hello:

I am attempting to count incidents by the day of the week across a month.   I am hoping for:

            MON   TUE   WED   THU   FRI   SAT   SUN

Shift A    3          6          2       5       11       8      7

Shift B    2          8          x       x         x        x      x

Shift C  and so forth.

Here is what I have so far, but I can't figure out how to tell SiSense to count only by one of the 7 days of the week and not duplicate the day of the week as pictured here:

Any help is greatly appreciated!

 

Darin Inda

 

  • Hi dinda156,

    Did you mean that the data model is a live model, or that you do not have access to the model? Do you have access to the Data tab (like shown below) at all? 

    The solution to your question requires changes to the data model (regardless of the model type, elasticube or live), so to achieve this, you'll need edit access to the model. Otherwise, you'll need to ask the data designer of the model to make the changes on your behalf.

5 Replies

  • Hi dinda156 ,

    If I understand the question correctly, one best approach would be to create a column in the Elasticube table that identifies the day of the week. You can then use this new column instead of 'Time in Alarm DateTime'  in your screenshot.

    To achieve this, use the following formula in Elasticube to get the day name:

    DayName(DayOfWeek([Table Name].[Date Field]))

    This will allow you to group and count incidents by the day of the week without duplication.

     

     

    Feel free to reach out if you have further questions, we're always happy to help 🙂
    [email protected] 
    Paldi Solutions, Number #1 Sisense Plugins Developer

     

    • dinda156's avatar
      dinda156
      Cloud Apps

      I probably should have mentioned I am in a cloud environment.  As such, no elasticube.   

      thanks!

    • dinda156's avatar
      dinda156
      Cloud Apps

      Hello:
      Working in our cloud environment, SiSense (Cloud) doesn't like DAYNAME. I cannot reference a table in the cloud, only the data element.  Our cloud implementation doesn't permit this. 

       

       

      • TriAnthony's avatar
        TriAnthony
        Admin

        Hi dinda156,

        Did you mean that the data model is a live model, or that you do not have access to the model? Do you have access to the Data tab (like shown below) at all? 

        The solution to your question requires changes to the data model (regardless of the model type, elasticube or live), so to achieve this, you'll need edit access to the model. Otherwise, you'll need to ask the data designer of the model to make the changes on your behalf.

  • Hello dinda156 ,

    I wanted to follow up to see if the solution offered by Benji_PaldiTeam and TriAnthony  worked for you.

    If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

    Thank you.